Change data in a single column from "last, first" to "first last"

[Guest]

I have a column of names that I want to export to a mail merge. It's a single
column with last name separated by comma followed by first name. How do I
change it to first name and last, no comma

 

[David McRitchie]

Hi Jeanne,

http://www.mvps.org/dmcritchie/excel/join.htm#firstname
for both macro solution and worksheet solution.

A worksheet solution is:
=TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1)
This allows for there to be a space or no space after the comma in the original.

 

[Guest]

H Jeanne,

If you Names are in Column A, and the last and first are separated by a ","
then:
In column B, you could put:
=MID(A1,FIND(",",A1)+2,LEN(A1)-(FIND(",",A1)+1))

Hope this helps.

 

[L. Howard Kittle]

Hi Jeanne,

In a helper column
=MID(A1,FIND(" ",A1),150)& " "&LEFT(A1,FIND(",",A1)-1)

Then do a copy > paste special > values to get rid of the formulas.

Also, Text to Columns under Data can seperate the names into seperate column
and then you would have to re-combine the names back into a single cell.
Paste special > values again.

HTH
Regards,
Howard