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 |
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 |
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 |
All times are GMT +1. The time now is 09:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com