Need to separate and rearrange names

  • Thread starter Thread starter Nadine
  • Start date Start date
N

Nadine

How do you take Last,First and change it to First Last?
Ex: Joe,John needs to be rewritten to John Doe.
Using Excel 2003 and having the formula be in a different cell than the text
it is converting so that the original text remains unchanged.
 
Assuming there is no space following the comma (both your examples show
that), give this formula a try...

=MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))
 
Actually, if your data could be mixed (some with a space after the comma and
some without one), then you can use this formula to handle both of those
conditions...

=TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))
 
This leaves lots of extra space between the two names. Gord Dibben's formula
worked perfect. Thanks for taking a stab at it though. I appreciate it.
 
This works. Thanks.

Rick Rothstein said:
Actually, if your data could be mixed (some with a space after the comma and
some without one), then you can use this formula to handle both of those
conditions...

=TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))

--
Rick (MVP - Excel)




.
Click to expand...
 
Back
Top