Sheets AcademySheets Academy
Premium
Task #40

Phone numbers in one format

Customer phone numbers are written in different ways. To import them into the CRM, you need one format: 11 digits starting with 1, for example 19123456789.

  1. In B2:B8, keep only the digits of the number.
  2. In C2:C8, bring the number to the format with 1: if it doesn't start with 1, add 1 in front.
Task #40
Phone numbers in one format

Customer phone numbers are written in different ways. To import them into the CRM, you need one format: 11 digits starting with 1, for example 19123456789.

  1. In B2:B8, keep only the digits of the number.
  2. In C2:C8, bring the number to the format with 1: if it doesn't start with 1, add 1 in front.