View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine char or number?

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