How about Find & Replace?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Ian" wrote in message
...
Is it possible to clear the contents of a cell if if contains a certain
text strings, i.e. I want to clear all cells in a particular column that
contain the phrases "son of", "dau of" and "wife of".
Thanks in advance.