Excel need to copy a cell if not containing one or more keywords
Posted on 2011-02-14
I need to check a column for particular keywords (more than one) , if found I need to change the content of that cell in a new column if not to just copy it to the new column.
I was hoping to use the IF and FIND statement to do this but if if the FIND fails than it puts #VALUE! in the corresponding cell in the new column.