Add International Phone Numbers in Bulk Update

Follow

Google Sheets does not allow you add in a number with a leading ‘+’ sign. As a workaround you can use the CONCATENATE function to combine the ‘+’ sign with any number.

  1. Enter ‘+ into cell A1
    Note: Be sure to include the leading apostrophe otherwise you will receive an error
  2. Enter the phone number into cell B1
  3. Enter =CONCATENATE(A1:B1) into cell C1
  4. Copy cell C1
  5. Paste special > Values only into cell C1 (this will paste the phone number rather than the formula into the cell)
  6. Copy the phone numbers to the users or contacts spreadsheet and import

The numbers will now appear with a ‘+’ sign in BetterCloud!

Video

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request