ExcelBanter - Changing the form of a name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Changing the form of a name (https://www.excelbanter.com/excel-worksheet-functions/114187-changing-form-name.html)

KeyMike

Changing the form of a name

How can I change a name that is in a "John Smith" format to "Smith, John"?
Thanks in advance for your help.
--
Michael Gudyka
St. Charles, IL

Biff

Changing the form of a name

Try this:

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

Biff

"KeyMike" wrote in message
...
How can I change a name that is in a "John Smith" format to "Smith, John"?
Thanks in advance for your help.
--
Michael Gudyka
St. Charles, IL

KeyMike

Changing the form of a name

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

"Biff" wrote:

Try this:

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

Biff

"KeyMike" wrote in message
...
How can I change a name that is in a "John Smith" format to "Smith, John"?
Thanks in advance for your help.
--
Michael Gudyka
St. Charles, IL

Biff

Changing the form of a name

You're welcome. Thanks for the feedback!

Biff

"KeyMike" wrote in message
...
Thanks a lot, Biff. That was perfect.
--
Michael Gudyka
St. Charles, IL

"Biff" wrote:

Try this:

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

Biff

"KeyMike" wrote in message
...
How can I change a name that is in a "John Smith" format to "Smith,
John"?
Thanks in advance for your help.
--
Michael Gudyka
St. Charles, IL

All times are GMT +1. The time now is 10:29 AM.