How to add country code to every number in Excel?

22 July 2022 by ProSender

Everyone has faced this issue of adding country code in front of contact numbers. Suppose your country code is +91 and you would like to add that in front of all the contacts. The simplest way to do that in Excel or spreadsheets is to use the function CONCATENATE. Here's how to use it:

First, make another column and add +91 (or whatever your country code is) in each cell of the column. You can do that by simply typing +91 in the first cell and dragging the pointer till the last cell. Like this:

Now, use the CONCATENATE function to add the country code in front of the contact numbers. Here's how to do that:

=CONCATENATE(A1, B1)

Here, A1 is the cell with the country code and B1 is the cell with the contact number. Drag the pointer till the last cell and you will have the country code in front of all the contact numbers.

This is the simplest way to add country code in front of all the contacts in Excel or spreadsheets.