Is the first character a number or letter
This is a bit more involved, but this will also tell you if the first
character is something other than a letter or number.
=IF(A1="","",IF(AND(CODE(LEFT(A1,1))=48,CODE(LEFT (A1,1))<=57),"Number",IF(OR(AND(CODE(LEFT(A1,1))= 65,CODE(LEFT(A1,1))<=90),AND(CODE(LEFT(A1,1))=97, CODE(LEFT(A1,1))<=122)),"Letter","Other")))
HTH,
Elkar
"bactfarmer" wrote:
I need a formula that tells you if the first character in a string is
a number or a letter.
Thanks
Very Cunfused
|