View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default Letter recognition

one way

IsNumeric(Left(Range("A1").Value, 1))
will be true if the first character is a number, false if it's a character



--


Gary


"General" wrote in message
...
Is there a simple formula that can recognised the first character in a cell
as being a letter as opposed to a number or symbol?

Thanks.