View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Minty Fresh Minty Fresh is offline
external usenet poster
 
Posts: 22
Default How to determine char or number?

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


"Eric" wrote:

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