Hi everyone,
I hope you are well and safe!
I would like to filter a column and find out phone numbers that contain string. Could you please help me with that.
I have attached the excel file.
Thanks,
Simon
Solved! Go to Solution.
Try this in a formula tool. Then filter. Is this what you meant?
Note: It ignores the + symbol and any () embedded in a phone number (so long as there is no space \s),
iif(REGEX_Match([Phone Number],"(.*)?\s\D(.*)?"),"False","True")