| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search string for number value
I have several cells
text text 232 text more text 80908 I want a formula to find the location of the first occurance of a number. something like find(#,a1) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
search string for number value
Assuming every cell will contain a number:
=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")) -- Biff Microsoft Excel MVP "samuel" wrote in message ... I have several cells text text 232 text more text 80908 I want a formula to find the location of the first occurance of a number. something like find(#,a1) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
search string for number value
Ctrl/Shift/Enter this:
=MATCH(FALSE,ISERROR(1*MID(A1,ROW(1:100),1)),0) In your example this returns 11. HTH Bob Umlas Excel MVP "samuel" wrote: I have several cells text text 232 text more text 80908 I want a formula to find the location of the first occurance of a number. something like find(#,a1) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
search string for number value
On Tue, 13 May 2008 13:19:03 -0700, samuel
wrote: I have several cells text text 232 text more text 80908 I want a formula to find the location of the first occurance of a number. something like find(#,a1) =MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") ) And, if you want to return that number: =LOOKUP(9.9E+307,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&" 0123456789")),ROW(INDIRECT("1:"&LEN(A1))))) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| How to search a string from the right ? | Setting up and Configuration of Excel | |||
| counting the number of instances of a string within another string | Excel Worksheet Functions | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Q: search in string | Excel Discussion (Misc queries) | |||
Linear Mode
