Extract phone numbers from text
Extracts phone numbers contained in text.
The first match is returned in international phone number format.
Note that the maximum length of the URL is 2048 characters, so long text will result in an error.
URL
https://api.excelapi.org/phone/find-phonenumber
Configuration
| Configuration | Required | Description |
|---|---|---|
| text | ✔ | Specify the text. |
| country | Specify the country code. If not specified, the default is JP (Japan). |
Example
=WEBSERVICE("https://api.excelapi.org/phone/find-phonenumber?text="&ENCODEURL(A2))