Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have the following cells and need a quick way to parse it into
separate cells. Each name needs to be in firstname lastname and each title in a single cell. The cell contents are not uniform so it is not possible to use the text to columns function. a1= "Dr Jim Jones | Mary Jones | Jim A. Jones" a2= "doctor of medicine | housewife | student at college" any help would greatly be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Independently Summing Multiple Text Options Within a Cell | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
Moving text from one cell to another. | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |