XL.FormatPhoneNumber function

XL.FormatPhoneNumber function – Text function type – parses the input text and formats it as a phone number. The possible formats are E164, INTERNATIONAL, NATIONAL, RFC3966.

Syntax

=XL.FormatPhoneNumber(phone, format, defaultRegion)

ArgumentDescription
phone
[required]
A text expression representing an input phone number.
format
[optional]
A preferred format for an output phone number. Supported formats:
  • E164
  • INTERNATIONAL
  • NATIONAL
  • RFC3966
defaultRegion
[optional]
Two letters of country code, e.g. US, CN, RU, FR, etc.

Any questions or suggestions?
How can we help?