Answer the question
In order to leave comments, you need to log in
Is there a program that converts phone numbers to a single format?
There is a database of Ukrainian mobile phones in Excel, people entered them manually, so there are numbers in the national format, there are in the international format, there are solid text, there are spaces and dashes. We need a program that will recognize them and bring them into a single format for the mailing service. Either free or cheap (up to $ 5), if more expensive - with such a volume it is easier to hire a person who will do it.
Answer the question
In order to leave comments, you need to log in
1. CTRL+H
Replace brackets with space, dash with space, space with space.
2. We filter through the first character "starts with"
Through the formula = REPLACE, you replace the first national characters with international ones.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question