How to Format Mobile Numbers for MobileConnect

To send SMS from SFMC, mobile numbers need to be in a specific format:

  • Example: 61400000000
  • No proceeding + symbol
  • Country code at the start, i.e. for Australia: 61
  • Mobile number with no spaces
  • No proceeding 0 on the mobile number (i.e. not 610400000000)

Step 1 – Remove leading 0s

SUBSTRING([Mobile Phone], PATINDEX('%[^0]%', [Mobile Phone]), LEN([Mobile Phone])) as [Mobile Phone]

Step 2 – Add the Country Code

concat('61',[Mobile Phone]) as [Mobile Formatted]