If your numbers are in Col A and all have the same pattern (two numbers
separated by " - ") then use this in B1
=MID(A1,1,FIND(" - ",A1)-1)
to get 6023
and this in C1

to get 10056.
You can copy down the formula.
=MID(A1,FIND(" - ",A1)+3,LEN(A1))

"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