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

%3CLINGO-SUB%20id%3D%22lingo-sub-2190219%22%20slang%3D%22en-US%22%3EHow%20to%20Filter%20rows%20in%20a%20table%20based%20on%20the%20presence%20of%20a%20text%20string%20value%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190219%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20have%20a%20huge%20table%20and%20need%20to%20find%20the%20full%20set%20of%20rows%20that%20have%20the%20text%20string%20of%20%22SSO%22%20in%20E%2C%20so%20that%20I%20can%20delete%20all%20those%20rows.%26nbsp%3B%20I%20cannot%20find%20a%20formula%20to%20do%20this.%20there%20must%20be%20a%20way%20to%20do%20it.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2190219%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2190237%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Filter%20rows%20in%20a%20table%20based%20on%20the%20presence%20of%20a%20text%20string%20value%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2190237%22%20slang%3D%22en-US%22%3ETypo%20in%20my%20request%20above.%20The%20text%20string%20that%20I%20need%20to%20filter%20all%20rows%20on%20in%20is%20Column%20E.%3C%2FLINGO-BODY%3E
New 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!