change first name last name to last name first name
 

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

last name first, first name last

change first name last name to last name first name
 

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

change first name last name to last name first name
 

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

change first name last name to last name first name
 

=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