How to select the numbers?

E

Eric

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
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve the value within string? 11
How to count the numbers in a Word document? 0
How to determine the value within specific cell position? 5
How to retrieve the value? 3
How to retrieve the sheet name? 2
How to select the value? 2
How to count the number of occurrence within string? 2
How to retrieve the values within cells? 6

Top