Thanks Bob..but i didnt understand ur question.


"Bob Phillips" wrote in message
...
Keep it simple

=IF(ISNUMBER(A3),"X",IF(A3="Y",""))

what about if not a number and not Y?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Gary" wrote in message
...
Ok.....this is what am trying to do.

If A3=alpha numeric,"X", if A3=text,"Y", Blank

any ideas?