Thread: Select a particular number from a rage of number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Select a particular number from a rage of number
As long as every number is the same length:

=--MID(A1,6,2)

Copy down as needed

--
Biff
Microsoft Excel MVP


"Cazumel" wrote in message
...
My situation
Range of numbers Isolate the middle number
511012407000 R7371 24
511312556110 F3938 25
511401094900 10
511401094900
511011091221 which formula would I need to use?
511011091221
511011091221
511011091221
Last question for the day thank you for helping



Reply With QuoteReply With Quote