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

=--TRIM(LEFT(A2,FIND("-",A2)-1))

and

=--TRIM(MID(A2,FIND("-",A2)+1,99))

--
__________________________________
HTH

Bob

"Eric" wrote in message
...
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

try this

Select Col A
Go to | data | text to column | delimited | next |
in other : give hyphen ( - ) | next | Destination | B1 |
Select the second part values i.e, after hyphen values |
Select do not import column(skip) | finish |



On Feb 12, 10:50*am, 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

Select Col A
Go to | data | text to column | delimited | next |
in Other : give hyphen ( - ) | next | Destination:= B1 | Finish


On Feb 12, 4:03*pm, muddan madhu wrote:
try this

Select Col A
Go to | data | text to column | delimited | next |
in other : give hyphen ( - ) | next | Destination | B1 |
Select the second part values i.e, after hyphen values |
Select do not import column(skip) | finish |

On Feb 12, 10:50*am, 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