I've a spreadsheet with product descriptions on some of which include the text *obsolete* which I want to remove.
eg Red car size small *obsolete*
which I want to simply show
Red car size small
Usually I'd use Ctrl+H and type the text I want to remove but if I include the symbol * it removes everything. I've removed the wording which now leaves me with ** at the end of the description but not sure how to remove this. I've tried checking the match case/cell contents but it still removes everything. Any suggestions welcome.
Bookmarks