Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st name last name to last name, 1st name
I have a column that has 1st name and last name. I want to change the column
to be last name, 1st name. Is there a way to do this without having to do each line of the column individually? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st name last name to last name, 1st name
Look he
http://www.cpearson.com/excel/FirstLast.htm -- Kind regards, Niek Otten Microsoft MVP - Excel "shan" wrote in message ... I have a column that has 1st name and last name. I want to change the column to be last name, 1st name. Is there a way to do this without having to do each line of the column individually? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
1st name last name to last name, 1st name
=MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1)
"shan" wrote: I have a column that has 1st name and last name. I want to change the column to be last name, 1st name. Is there a way to do this without having to do each line of the column individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|