how to extract digits from a row of numbers
If the number of characters are *exactly* as your example, try this:
=LEFT(RIGHT(A1,11),5)
OR
=LEFT(RIGHT(TRIM(A1),11),5)
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"preydd" wrote in message
...
I have these data in a column:
5100-10650 sales
5100-11250 sales
How can I extract only 10650 and 11250 and present it in another column?
Thanks.
|