delete cell if part of cell contains
Check your other post.
ppeer wrote:
For a worksheet I would like to check the cells if they contain the
word "text".
Within a cell this word is always combined e.g.: text 06735
When the cell contains "text" I would like to clean the whole cell, so
text including e.g: 06735.
Result: a blank cell.
Please, can somebody help me out?
--
Dave Peterson
|