| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to select group of 77 number | Excel Discussion (Misc queries) | |||
| Save RAND select number | Excel Discussion (Misc queries) | |||
| How to select the number in excel? | Excel Worksheet Functions | |||
| Select a certain number of cells in a row | Excel Discussion (Misc queries) | |||
| Select unused number | Excel Worksheet Functions | |||
Hybrid Mode
