sum comma separated numbers seen as strings

[WyattNW]

My report is meant to show by employee and by category total expenses.  Im trying to sum values that are separated by commas with respect to each category, A category for example is "Dinner Max 18.90". 

My main issue is i cant convert the Comma separated numbers into single rows that respect the category there a part of. any help would be appreciated.