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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If A3=alpha numeric,"X", if A3=text,"Y", Blank (https://www.excelbanter.com/excel-programming/369562-if-a3%3Dalpha-numeric-x-if-a3%3Dtext-y-blank.html)

Gary

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?

Gary

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

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?

Bob Phillips

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

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?

All times are GMT +1. The time now is 08:36 AM.