If cell contains AlphaNumeric "True"
While I'm sure there is probably a shorter formula that will do what you
want, give this a try in the meantime...
=AND(SUMPRODUCT(--ISNUMBER(SEARCH(MID(A1,ROW(INDIRECT("A$1:A"&LEN(A1 ))),1),"abcdefghijklmnopqrstuvwxyz")))0,SUMPRODUC T(--ISNUMBER(--MID(A1,ROW($1:$999),1)))0)
This formula returns TRUE for entries with both numbers and letters (but not
non-letters, non-digits, such as punctuation) in them and FALSE otherwise.
--
Rick (MVP - Excel)
"Carol" wrote in message
...
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
|