How to Filter rows in a table based on the presence of a text string value in a column

Copper Contributor

 I have a huge table and need to find the full set of rows that have the text string of "SSO" in E, so that I can delete all those rows.  I cannot find a formula to do this. there must be a way to do it. Any ideas?

3 Replies
Typo in my request above. The text string that I need to filter all rows on in is Column E.

@Susan Hinton If this is a one time exercise, put a filter on the table, select SSO in column E and delete the rows that are shown. Now, clear the filter.

OMG, what an idiot I am. I did not see that Search in the filter space. Thanks!