Wildcard for finding the first numeric digit in a cell?

L

lovemuch

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

=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

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.
 
Top