Excel 2003 - Changing FirstName LastName to LastName, Firstname

[Guest3731]

Hi - quick question, if you have a moment - I've got a (tall) column
of names of the format:

FirstName LastName

I want to convert them to the format:

LastName, FirstName

Is this possible in Excel 2003?

Thanks very much -

 

[Peo Sjoblom]

Assume they start in A1, insert a new column B or use the one you
have if it is empty, then in B1 put

=MID(A1,FIND(" ",A1)+1,255)&", "&LEFT(A1,FIND(" ",A1)-1)

press enter

Select B1 again, move the cursor to the lower right corner of B1 and when it
changes
from a thick cross to a think double click and copy down the formula.
Select the help column (B) and copy and paste special as values in place.

Finally after checking that everything is as you want delete column A


--


Regards,


Peo Sjoblom

 

[Bob Phillips]

=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+2)

 

[Harald Staff]

If however reality bites and you encounter names like
Dr. John Luis Wallace Montgomery Jr.
then it gets a little more complicated. See
http://www.dailydoseofexcel.com/archives/2005/02/03/parse-names-with-outlook-array-formula/
for a (also a little more complicated) solution to that.

Best wishes Harald