Delete a cell value if not "like"

Giganews Newsgroups
Subject: Delete a cell value if not "like"
Posted by:  Kryten (Kryten…@googlemail.com)
Date: Mon, 21 Jul 2008

Hi,
Would it be possible to delete cell contents based on the value of
that cell.

Eg if the cell contains anything EXCEPT "*IMPORTANT*" then the content
would be cleared.

Thanks,
Stuart

Replies