Add country code
I need to add country code to a number by replace its first digit 0 with +971
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
Add country code