G Guest Aug 17, 2006 #1 In word this is referred to "any digit" and the text you use to find it is "^#". Is there something similar in Excel? Thanks! Cynthia
In word this is referred to "any digit" and the text you use to find it is "^#". Is there something similar in Excel? Thanks! Cynthia
B Bob Phillips Aug 17, 2006 #2 =IF(MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},D1&"0123456789"))>LEN(D1),0,MIN(SEARCH( {0,1,2,3,4,5,6,7,8,9},D1&"0123456789"))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=IF(MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},D1&"0123456789"))>LEN(D1),0,MIN(SEARCH( {0,1,2,3,4,5,6,7,8,9},D1&"0123456789"))) which is an array formula, it should be committed with Ctrl-Shift-Enter, not just Enter. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
H Harlan Grove Aug 17, 2006 #3 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? Click to expand... 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.
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? Click to expand... 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.
H Harlan Grove Aug 17, 2006 #4 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? Click to expand... 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.
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? Click to expand... 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.
