Select a particular number from a rage of number

  • Thread starter Thread starter Cazumel
  • Start date Start date
C

Cazumel

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
 
As long as every number is the same length:

=--MID(A1,6,2)

Copy down as needed
 
Thank you , when you can if you could explain to me what each step is doing ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rage 2 8
Need help finding a soution for Excel formula 2
Excel Formula 2
finding 10 smallest numbers from last 20 input 8
lotto numbers 2
if function with multiple criteria 4
Duplicate Item Numbers 3
Numbering years and months 4

Back
Top