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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Jeanne" wrote in message ...
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