Tips and Tricks

How To Add Country/Area Code To A Phone Number List In Excel?

Add Country/Area Code To A List Of Phone Number With Formula

Select a blank cell next to the phone number, take instance, C1, type this formula =”020″&A2 into it, and press Enter key, the drag the AutoFill handle from the right corner of the cell down to fill this formula to the cells you need. See screenshots:

Tip: In the formula, “020”is the area code or country code you want to add to each phone number, and A1 is the cell you want to add code number, you can change them as your need.

Dollar Buy Sell Web Site Make


Get all Tech News, Freelancing Tips, Computer Tips, Earn Money Online Tips in Bangla, Latest Tech News of Bangladesh, Domain Registration, Web Hosting, Web Design and Development.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Open chat
Hello 🙄
Can we help you?