Excel Help

M

Myra

I'm trying to convert the last name first, then first name because my
accounting software ables me to convert to excel but puts the first names
first. How can I do this? I was told to do this formula: =Proper(A2) enter
but this still kept the first name first.

Myra
 
P

Pete_UK

PROPER just gives you initial capital letters !!

If you have "First Last" in A1 (without the quotes), put this formula
in B1:

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&" "&LEFT(A1,SEARCH(" ",A1)-1)

to give you:

Last First

If you need a comma to separate them, change the middle &" "& to &",
"&, then copy down as required.

Hope this helps.

Pete
 
Top