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

On Feb 2, 3:22*pm, Myra wrote:
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