Hi!
I'm pulling large amounts of data to excel file from 2 databeses (websites)
I have one database of phone numbers that I download to excel as xxx-xxx-xxxx
Another database of phone numbers I download to excel as (xxx)xxx-xxxx
Often I need to find a match of a multiple phone numbers, so I need to have them in the same format.
How can I convert in excel one to another between those 2 formats using function or formula?
Also
How can I convert format (xxx)xxx-xxxx to just xxxxxxxxxx?
Thanks
Bookmarks