Forum Discussion
How to Filter rows in a table based on the presence of a text string value in a column
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
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!
- Typo in my request above. The text string that I need to filter all rows on in is Column E.
