ExcelBanter - hoping for help

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

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

- - hoping for help (https://www.excelbanter.com/excel-programming/389062-hoping-help.html)

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

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