Excel 2003 - Changing FirstName LastName to LastName, Firstname

  • Thread starter Thread starter Guest3731
  • Start date Start date
G

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 -
 
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
 
Back
Top