| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing: Last, First to First Last name
The comma is genuine - it's an as400 export. Works great and thanks.
"Mike H" wrote: Hi, With your names in a1 put this in b1 and drag down as reqired =MID(A1,FIND(" ",A1)+1,999)&" "&LEFT(A1,FIND(" ",A1)-1) If the comma is genuine and not a typo you can remove it with this mod =MID(A1,FIND(" ",A1)+1,999)&" "&LEFT(A1,FIND(" ",A1)-2) Mike "Charlie7805" wrote: Can this be done? Doe, John to John Doe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing footers on all worksheets without changing print set up | Excel Discussion (Misc queries) | |||
| changing a cell to changing the link | Excel Worksheet Functions | |||
| NOW() keeps changing | Excel Discussion (Misc queries) | |||
| changing value | Excel Discussion (Misc queries) | |||
| Changing format of number without changing the value | Excel Discussion (Misc queries) | |||
Threaded Mode
