How do I switch the names in a column in Excel

  • Thread starter Help Me - I need to switch these names
  • Start date
H

Help Me - I need to switch these names

I am trying to switch the names in a column in Excel and I found information
on how to do this last time I looked but can no longer find it - name is in
the following format
Smith John and Mary
and I want it to read
John and Mary Smith
I know this is a several step process and the steps were on the internet
last time I looked but know I can't find it
Somebody Please Help Me
Down but not out in Weeki Wachee Florida
 
D

Duke Carey

This assumes that the last names are all one-word names, no St. John type names

=MID(A1,1+SEARCH(" ",A1,1),255)&" "&LEFT(A1, SEARCH(" ",A1,1))
 
A

Alan

I'm assuming that there should be a space between Smith and John, if so
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1))
If not I don't know as there's nothing to look for to find the end of one
name and the start of the next one,
Regards,
Alan.
"Help Me - I need to switch these names" <Help Me - I need to switch these
[email protected]> wrote in message
news:[email protected]...
 
Top