Changing the order of a name in various cells

H

happydude

I have a column with over 400 rows of names that most contain names reading last name first then a comma then a persons first name. Such as Sullivan, Mike. How can I change the order to read first name then last name without the comma? Such as Mike Sullivan.

Thank you for looking.
 
A

Arvi Laanemets

Hi

With entry in A1:
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1) & " " & LEFT(A1,FIND(",",A1)-1)


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


happydude said:
I have a column with over 400 rows of names that most contain names
Click to expand...
reading last name first then a comma then a persons first name. Such as
Sullivan, Mike. How can I change the order to read first name then last
name without the comma? Such as Mike Sullivan.
 
Top