How Can I switch string

Hello EE,

Can someone please help me with an excel formula to remove comma and switch the string before the commas to the end of the string? I have the following example:

III, Wallace James
Janet Rhodes,
Adu, Mary Ann

Should be

Wallace James III
Janet Rhodes
Mary Ann Adu

Thanks in advance for your help
Who is Participating?
I wear a lot of hats...


Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Assuming your string is in A1 then try this.....
In B1
=TRIM(RIGHT(A1,LEN(A1)-FIND(",",A1))&" "&REPLACE(A1,FIND(",",A1),255,""))

Open in new window

Edit: Or this after including the error handling.

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.


Start your 7-day free trial
fb1990Author Commented:
Thank you very much Sir.  Worked like a charm!
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You're welcome. Glad to help.
Microsoft Excel

From novice to tech pro — start learning today.