Thanks so much! It worked!! Now I need to get rid of the Middle initials
for those entries that have them. Can you also assist with this?



"Ken Wright" wrote:

Using a helper column B, assuming your data in Col A starting A2, in cell B2
put

=MID(A2,FIND(",",A2)+1,LEN(A2))&", "&LEFT(A2,FIND(",",A2)-1)

and copy down.

Copy and paste special as values to lose the formulas.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------

"workfordance" wrote in message
...
I have a spread sheet of client names and need to rearrange the order of
them
from Lastname, Firstname to Firstname Lastname.

Please help!