View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] krcowen@aol.com is offline
external usenet poster
 
Posts: 109
Default Is the first character a number or letter


try something like


=ISNUMBER(LEFT(A1,1)*1)

where A1 is the string you are evaluating. Multiplying the leftmost
character by 1 seems to be necessary to keep it from being considered
a text string that looks like a number.

Good luck.

Ken
Norfolk, Va


On Jan 30, 1:15 pm, "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