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

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



"Help Me - I need to switch these names" wrote:

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

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
wrote in message
...
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