| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to swap last name, first name in a cell to first name last
I need to swap last name, first name in a cell to first name last
Need formula |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to swap last name, first name in a cell to first name last
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))&" "&LEFT(A1,SEARCH(" ",A1)-1)
HTH -- AP "Wink" a écrit dans le message de news: ... I need to swap last name, first name in a cell to first name last Need formula |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to swap last name, first name in a cell to first name last
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)&" "&LEFT(A1,FIND(",",A1)-1)
-- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "Wink" wrote in message ... I need to swap last name, first name in a cell to first name last Need formula |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to swap last name, first name in a cell to first name last
A bit shorter alternative
=MID(A1&" "&A1, FIND(",",A1)+2,LEN(A1)-1) -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "Bob Phillips" wrote in message ... -- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "Wink" wrote in message ... I need to swap last name, first name in a cell to first name last Need formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
