Mar 12, 2020 10:53 AM
We have a distributor who sends us sales reports based on weekly orders. Some of these orders are from companies brand new to us. Of course, there is the legal name of the business, the dba and then sometimes the primary owner's name. I could be searching and end up with unknown duplication. As the phone number is a primary source, it would be helpful to search by phone number.
phone number formats
1234567890 (least desirable format)
123 456 7890
an efficient way to bulk format phone numbers?
an efficient way to search phone numbers? (I have a filter and then sort where formatting gets in the way)
any thoughts? ideas? etc....
Solved! Go to Solution.