HI,

If you want the number returned as text:
=TRIM(LEFT(A1,FIND("-",A1)-1))
=TRIM(MID(A1,FIND("-",A1)+1,10))

If you want it returned as a number:
=--TRIM(LEFT(A1,FIND("-",A1)-1))
=--TRIM(MID(A1,FIND("-",A1)+1,10))

In all cases the text was in A1

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric