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