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!
Solved! Go to Solution.
Add this formula to your filter
Regex_Match([Phone],"\d{10}") = -1