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

Ok.....this is what am trying to do.

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

any ideas?

Sorry.....it was supposed to be in worksheet functions...posted here by
mistake.


"Gary" <[email protected]> wrote in message
news:[email protected]...
> Ok.....this is what am trying to do.
>
> If A3=alpha numeric,"X", if A3=text,"Y", Blank
>
> any ideas?
>

You have two responses there already.

--
HTH

Bob Phillips

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

"Gary" <[email protected]> wrote in message
news:%23yId0%[email protected]...
> Sorry.....it was supposed to be in worksheet functions...posted here by
> mistake.
>
>
> "Gary" <[email protected]> wrote in message
> news:[email protected]...
> > Ok.....this is what am trying to do.
> >
> > If A3=alpha numeric,"X", if A3=text,"Y", Blank
> >
> > any ideas?
> >
>
>