View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Is the first character a number or letter

"bactfarmer" wrote...
I need a formula that tells you if the first character in a string is
a number or a letter.


One way, at least for English letters,

=IF(s<"",LOOKUP(CODE(s),{0;48;58;65;81;97;123},
{"other";"numeral";"other";"letter";"other";"lette r";"other"}),"")