| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing from relative to absolute cell reference in multiple form | Excel Worksheet Functions | |||
| Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
| Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
| Allow user to fill in on-line form without changing formatting | Excel Worksheet Functions | |||
| Changing lookup form numbers to alphabetics | Excel Worksheet Functions | |||
Linear Mode
