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