| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing: Last, First to First Last name
Can this be done?
Doe, John to John Doe |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing: Last, First to First Last name
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing: Last, First to First Last name
One way:
=TRIM(MID(A1,FIND(",",A1)+1,255) & " " & LEFT(A1,FIND(",",A1)-1)) In article , Charlie7805 wrote: Can this be done? Doe, John to John Doe |
|
#4
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 |
| Reply |
| 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) | |||
Linear Mode
