View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default 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.