how to remove spaces before commas

[bulletproof]

hi guys.

sorry for being a newb but would any of you
would be kind enough to show me a formula for:

what I have:

last name , first name
last name, first name
last name , first name

what i need to do:

last name, first name
last name, first name
last name, first name


as you can see, some of those last names have spaces before the commas. I need to get those spaces out.
I understand that the TRIM function only deals with the spaces before
and after and the trailing ones.

I tried to search for it, though not quite successful in my chosen keywords.

I'm just an old dog trying to learn new tricks from excel.

thanks much.

 

[mikerickson]

what do you want from joannesmith?

joan nesmith
or
joanne smith

 

[bulletproof]

"dale,paul"

How does Excel work out which is the first and second name?

hmmm.... i got you.
it makes sense now.
sorry for being slow.

I guess i would sort it out individually.

not that to many, i hope :D

thanks again.

 

[bulletproof]

what do you want from joannesmith?

joan nesmith
or
joanne smith

now that is a challenge.

as per VoG's reply,
i'm not quite sure if excel can determine which is which.

from your sample,

i would usually go for joanne smith...