Changing the form of a name

[Guest]

How can I change a name that is in a "John Smith" format to "Smith, John"?
Thanks in advance for your help.

 

[Biff]

Try this:

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

Biff

 

[Guest]

Thanks a lot, Biff. That was perfect.
--
Michael Gudyka
St. Charles, IL

Try this:

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

Biff

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thanks a lot, Biff. That was perfect.