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