| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |
|
|
Hybrid Mode
