Thread: Is the first character a number or letter
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Is the first character a number or letter
=IF(ISERR(LEFT(A1,1)*1),"letter","number")


"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


Reply With QuoteReply With Quote