software

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 commaHi Jeanne,

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

A worksheet solution is:
=TRIM(MID(A2,FIND(quot;,quot;,A2) 1,99))amp;quot; quot;amp;LEFT(A2,FIND(quot;,quot;,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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Jeannequot; gt; wrote in message ...
gt; I have a column of names that I want to export to a mail merge. It's a single
gt; column with last name separated by comma followed by first name. How do I
gt; change it to first name and last, no comma
gt;
H Jeanne,

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

Hope this helps.