Reversing order of text
 

Within a cell, how do I reverse the position of a last name, first name to
first name then last name? Ex: Doe John to John Doe or Doe, John to John Doe.

Reversing order of text
 

For names including a comma, use:
=MID(A1,FIND(", ",A1)+2,255) & " " & LEFT(A1,FIND(",",A1)-1)
For names without a comma, use:
=MID(A2,FIND(" ",A2)+1,255) & " " & LEFT(A2,FIND(" ",A2)-1)
--
Gary''s Student - gsnu200909


"Sonics" wrote:

Within a cell, how do I reverse the position of a last name, first name to
first name then last name? Ex: Doe John to John Doe or Doe, John to John Doe.

Reversing order of text
 

Hi,
In an adjacent cell enter

=TRIM(RIGHT(D9,FIND(" ",D9)+1))&","&TRIM(LEFT(D9,FIND(" ",D9)))

change range to fit your needs

"Sonics" wrote:

Within a cell, how do I reverse the position of a last name, first name to
first name then last name? Ex: Doe John to John Doe or Doe, John to John Doe.