Could you give some examples of what you mean?

"Sunrays17" wrote:

Hi there...

i am looking forward to know is there any formula to know if a value
is alphanumeric too, as well as its a number or a letter...

Take care...
Sunrays17

On Jan 30, 11:41 pm, Elkar wrote:
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))=9 7,Â*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- Hide quoted text -- Show quoted text -