| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hoping for help
Hi, I am pretty new to excel and need to know how to do the following.
I need to have the formula check a cell and see if it contains one of about 30 different words...if it does then do nothing. If it does not I need the formula to replace whatever is in the cell with the word NONE. Any help will be appreciated |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hoping for help
In code you can use application.match to check the value for one of the words
Where are the 30 words, in a range ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... Hi, I am pretty new to excel and need to know how to do the following. I need to have the formula check a cell and see if it contains one of about 30 different words...if it does then do nothing. If it does not I need the formula to replace whatever is in the cell with the word NONE. Any help will be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hoping to disable Protection Warning message | Excel Discussion (Misc queries) | |||
| Weird Problem..hoping to find a solution | Excel Worksheet Functions | |||
| Hoping | Excel Programming | |||
| simple i am hoping with macros | Excel Discussion (Misc queries) | |||
| Hoping its an easy question | Excel Programming | |||
Linear Mode
