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