| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wildcard for finding the first numeric digit in a cell?
lovemuch wrote...
In word this is referred to "any digit" and the text you use to find it is "^#". Is there something similar in Excel? If you need to do this often, define a name like seq referring to =ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,1024,1)) then use the array formula =MIN(IF(ISNUMBER(-MID(x,seq,1)),seq)) to find the first decimal numeral in x. It returns 0 if there are none. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| need excel to look for the 4th digit in a cell then insert new num | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
