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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separate text string 5
Formula for names 6
Separate first name, middle name and last name 2
Separate First Name MI and Last Name into three Cells 3
Rearranging a report 7
Separating Text 2
Need to alphabetize data from separate cells within same row 2
Change Names to E-Mail addresses Q 4

Back
Top