I LOVE this forum. Very helpful.

In Excel 2007, I've got 2 columns of data...
FirstName LastName
Joe Smith
Mary Jones
but SOME of the data are now in the format...
Doe, John
I want them all like...
John Doe
How can I go thru the columns and...
Find any COMMAs in the FirstName column (that is actually a
LastName),
Anytime there is a comma, Delete the comma,
Move the JOHN to the Previous column, and
Move the SMITH to Next column.


If it takes several steps... no problem.


Thanks very much, people.


Mark246