How to determine char or number?

[Eric]

There is a string in cell A1, which contain char or number. I would like to
return 1 if the left(A1,1) is char, or return 2 if left(A1,1) is number.
Does anyone have any suggestions on how to determine char or number for the
first character of string?
Thanks in advance for any suggestions
Eric

 

[Mike H]

Hi,

Try this

=ISNUMBER(LEFT(A1,1)+0)+1
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Jacob Skaria]

Try
=LOOKUP(CODE(A1),{0,48,58,65,91,97,123},{"",2,"",1,"",1,""})

 

[Jacob Skaria]

Checkout help on the below two functions

=T()
=N()

 

[Minty Fresh]

Hi Eric
This will do the trick:
=IF(ISERROR(LEFT(A1,1)*1),1,2)