You have two responses there already.

--
HTH

Bob Phillips

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

"Gary" wrote in message
...
Sorry.....it was supposed to be in worksheet functions...posted here by
mistake.


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

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

any ideas?