View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.