LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default help parsing multiple text sets from one cell

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Independently Summing Multiple Text Options Within a Cell Bob Phillips Excel Worksheet Functions 0 April 21st 05 12:05 AM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM
Text wider than one cell is not displayed in the next empty cell Len Pace Excel Discussion (Misc queries) 5 February 18th 05 12:24 AM
Moving text from one cell to another. estaban botas Excel Worksheet Functions 1 December 15th 04 02:04 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"