Searching phone number with search bar

Jimmy_Ruptash1 · 06-29-2021 07:46 AM

Hello,

I have a customer list of 1300 customers that can be searched with their full name. However, we use a lot the phone number as a unique ID in other systems. So I toggle the option, however, the phone format is (xxx)-xxx-xxxx and it doesn’t seem to work unless I write it exactly like it is. Is there a simple formula to search it only by numbers?

Marc_Dillon

You can’t modify the search bar’s behavior at all. What you could do is use SUBSTITUTE to remove any special characters from a phone number, and hold the result (of just numbers) in a separate column, and search on that column.