Does anyone have any suggestions on how to select the numbers within a string?
For example, in cell A1, there is a string 6023 - 10056. I would like to
retrieve any number before "-" in cell B1, it should return 6023, and I would
like to retrieve any number after "-" in cell C1, it should return 10056.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

As responsed in your earlier query yesterday
----------
Easiest way is via Data Text to Columns
Select the col containing such data
(ensure you have empty cols to the right)
Click Data Text to Columns Delimited
In step 2, enter a dash (-) in the "Other" box, click Finish
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"Eric" wrote:
Does anyone have any suggestions on how to select the numbers within a string?
For example, in cell A1, there is a string 6023 - 10056. I would like to
retrieve any number before "-" in cell B1, it should return 6023, and I would
like to retrieve any number after "-" in cell C1, it should return 10056.