How to add country code to every number in excel?


Everyone has faced this issue of adding country code in front of contact numbers. Suppose your country code is +62 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 +62( or whatever your country code is) in each cell of the column. You can do that by simply typing +62 in the first cell and dragging the pointer till the last cell. Like this :



Once this is done, in the column besides the number, type  ' =CONCATENATE(Column1, Column2)'
Remember, Column1 is +62 and Column2 is the contact numbers. This is how it will look :





The + sign can be later formatted if it's needed.




 

Comments

Popular posts from this blog

How to send personalised messages on WhatsApp

Schedule a message