Thread: Changing the form of a name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default 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


Reply With QuoteReply With Quote