View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default Extrapolate numeric values from text string

MarcusA wrote...
How can I test for a numeric value in the first position of a text string?


If you mean a decimal numeral as first character, try

=COUNT(-LEFT(string,1))

The negative sign just before LEFT is intentional.