Select a particular number from a rage of number
 

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

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

Select a particular number from a rage of number
 

Thank you , when you can if you could explain to me what each step is doing ...

"Cazumel" wrote:

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

Select a particular number from a rage of number
 

If you are intending to reply to a particular message, make sure that you
reply to that, rather than to your own original message. When you do so,
please quote enough of the original message to put your reply into context.

If you are replying to the suggestion of using the MID function, MID is a
standard Excel function and it, along with every other Excel function but
one, is explained in Excel help. If the part that is confusing you is the
double unary minus before the MID function, that is a simple way of
converting either a Boolean logical value, or in this case a text value
(from the MID function), to a number. If you are starting with a text
number 1, or a Boolean TRUE, the first minus converts this to -1, and then
the second minus converts it to +1.
--
David Biddulph

"Cazumel" wrote in message
...
Thank you , when you can if you could explain to me what each step is
doing ...

"Cazumel" wrote:

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