Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |