| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Flipping the order of words in a column to a new column
If you have one column that reads Jane Doe can you easily reverse the order
to read Doe Jane by creating a formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flipping the order of words in a column to a new column
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1) "rachel" wrote: If you have one column that reads Jane Doe can you easily reverse the order to read Doe Jane by creating a formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flipping the order of words in a column to a new column
rachel wrote: If you have one column that reads Jane Doe can you easily reverse the order to read Doe Jane by creating a formula? Hi Rachel, If there is only first and last name and they are all seperated by a space you can use something like this: =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))&" "&LEFT(A1,FIND(" ",A1,1)) Regards, Bondi |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Flipping the order of words in a column to a new column
On Fri, 21 Jul 2006 07:41:03 -0700, rachel
wrote: If you have one column that reads Jane Doe can you easily reverse the order to read Doe Jane by creating a formula? For a two word separated by a space phrase in A1: First Word: =LEFT(A1,FIND(" ",A1)-1) Second Word: =MID(A1,FIND(" ",A1)+1,255) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
Hybrid Mode
