| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you flip the order of the content in a cell.
How do I flip the order of the content in a cell. i.e if the cell reads
Michael Smith how do I get it to flip to Smith Michael without having to retype. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you flip the order of the content in a cell.
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1)
-- David Biddulph "MLD" wrote in message ... How do I flip the order of the content in a cell. i.e if the cell reads Michael Smith how do I get it to flip to Smith Michael without having to retype. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you flip the order of the content in a cell.
This formula will flip the two as you have shown...
=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1)) However, if you want to flip them and put a comma separator in the flipped text, use this formula... =MID(A1&", "&A1,FIND(" ",A1)+1,LEN(A1)+1) Rick "MLD" wrote in message ... How do I flip the order of the content in a cell. i.e if the cell reads Michael Smith how do I get it to flip to Smith Michael without having to retype. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| how do i flip words in a cell (not picture) in excel? | Excel Discussion (Misc queries) | |||
| How do I flip the order of a column? (it is sequintial, so not sor | Excel Discussion (Misc queries) | |||
| How do I reverse the row order in Excel, not based on content? | Excel Discussion (Misc queries) | |||
| I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
Hybrid Mode
