thanks andy. It works if the cell is singularly the word "text" and nothing else.

If I have a cell which is something like "old text" or "type of text" then I want those cells empty as well.
As long as the cell contains "text" either on its own or with other words then I need the cell emptied.

Thanks