Add country code
I need to add country code to a number by replace its first digit 0 with +971
I suggest something like this:
select cell B2, then type, or copy and paste from here, the formula:
="+971"&RIGHT(A2,9)
shorthand for this is:
B2="+971"&RIGHT(A2,9)
now select cell B2, copy
select cells B2 thru the end of column B, or as needed, paste