| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
REVERSE SINGLE CELL TEXT STRING
I have a spreadsheet that lists names in a single cell (John Smith) I want
it to read as (Smith, John) in the cell to the left. Can you please advise on how I can accomplish this. thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
REVERSE SINGLE CELL TEXT STRING
http://www.cpearson.com/excel/FirstLast.htm
-- Gary's Student "Tammy" wrote: I have a spreadsheet that lists names in a single cell (John Smith) I want it to read as (Smith, John) in the cell to the left. Can you please advise on how I can accomplish this. thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
REVERSE SINGLE CELL TEXT STRING
As long as the names have only two words:
=MID(A2&", "&A2,FIND(" ",A2)+1,LEN(A2)+1) John Smith returns: Smith, John If some names are more than 2 words then I'm not sure how to do it because there are too many variables to consider. For example: John Lee St. Pierre Jr. ??????? Biff "Tammy" wrote in message ... I have a spreadsheet that lists names in a single cell (John Smith) I want it to read as (Smith, John) in the cell to the left. Can you please advise on how I can accomplish this. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup partial text from a single cell | Excel Worksheet Functions | |||
| Find & Replace text format | Excel Discussion (Misc queries) | |||
| Return a formula as text string to a cell | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
Linear Mode
