I have few hundreds of thousands lines of data. I would like to delete all the lines that do NOT contain a certain set of letters within a cell.
For example, I have attached a sample sheet and I would like only the lines that contain "ora" (part of the word "orange") to remain. Would deleting/hiding the other lines (e.g. Melon) be possible?
If not, would there be a formula that I could use in a separate column to indicate the lines I need and just filter them?
Thank you very much indeed.
Bookmarks