One thought is to tinker with Data Text to Columns
On a spare copy of your data sheet, select the column data range, then click
Data Text to Columns Check "Delimited" Next Check "Space" Finish.
This will isolate all data fragments into its own cell/col. Clean up by
selecting the "unwanted" portions, right-click on these (in turn) Delete
Shift cells left OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"David P." wrote:
I need a formula that will isolate cell phone numbers in two different cells
(A1 & B1). Please see the example below to explain this: I thought the best
way to do that was to find what is in betwee "/ " & " CE" (as in the 1st
example) or between the beginning of the cell and " CE" (2nd example). I
always put " CE" after a cell phone number as a standard. I likewise always
use "/ " everytime I'm seperating two numbers. There are cases where there
will be no "/ " since there is only one number. Here's the idea:

340-8688 / 818-444-6122 CE (This would be A1)
775-8844 (This would be B1)

Or in some cases I may have it like this with no "/ " and no area code for
example:

818-6122 CE (cell A1)
775-8844 (cell B1)

I need to render the cell phone only i.e. 818-444-6122 (1st example) or
818-6122 (2nd example).