View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carol Carol is offline
external usenet poster
 
Posts: 115
Default If cell contains AlphaNumeric "True"

I have a column where cells will contain one of the following:
" " (blank)
A9999 (A=Alpha/9=Numeric)
A (A=Alpha)

The alpha and numeric characters will vary from cell to cell.

I need a formula that will enter TRUE (or some kind of indicator) if the
cell contains alpha/numeric characters. Is this possible? Thank you!

....I do NOT know VBA.... Just thought you should know that!

--
Carol