This would be easier with an actual workbook to look at showing before/after examples, people so often say one thing and mean another, often quite different.

But if you just want to remove all instances of a text string from a worksheet:

1) Highlight the range of cells to include
2) Press CTRL-H to open the Search/Replace window
3) Enter the search string and leave the replace blank
4) Click on Replace All