You are amazing - I only wish I was capable of THAT kind of excel wizardry.
This works perfectly - thank you so very much!
--
Carol


"Rick Rothstein" wrote:

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