Removing Rows from Your Data Based on a Condition

[jenner85]

Hi - 

How would I go about removing entire rows of data based on what a particular cell in the row contains?

For example I have a list of Names and Numbers, and I want to remove anything that is not a phone number

Employee	Phone
Joe	6135553695
Anna	6135552987
Circuit	H88AHDB54
Bob	6135558796
Server	S7875GTT1

I would like to remove any rows that do not contain only numbers in the "Phone" column.

Thanks!

[rarmstrong · Accepted solution]

Add this formula to your filter

Regex_Match([Phone],"\d{10}") = -1