I need to change a column that has first name first and last name last to:

last name first, first name last

Hi

Assuming your data is in column A and the names are separated by a space
then in column B enter
=MID(A2,FIND(" ",A2)+1,99)&" "&LEFT(A2,FIND(" ",A2)-1)
Copy down as far as required.
Then, copy column B and Paste SpecialValues to fix the data.

If your data is separated by a comma, then insert a comma between the double
quotes in both instances
in the above formula ","

--
Regards
Roger Govier

"Doris smith" <Doris wrote in message
...
I need to change a column that has first name first and last name last to:

last name first, first name last

If you have always two name element separated by one space then, the name
being in A1:
=MID(A1,SEARCH(" ",A1)+1,256)&" "&LEFT(A1,SEARCH(" ",A1)-1)
Adjust cell reference and fill it down as necessary!

Regards,
Stefi


€žDoris smith€� ezt Ã*rta:

I need to change a column that has first name first and last name last to:

last name first, first name last

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

and copy down
--
Gary''s Student - gsnu200835


"Doris smith" wrote:

I need to change a column that has first name first and last name last to:

last name first, first name last