How to Make Phone Number Callable in Google Sheets.


If you click an email link on any web page, It opens your default mail program. Similarly, You can make phone numbers on your website “callable” meaning when someone clicks the phone number, It will launch the dialer on their cell phone and initiate dialing of the specified number. It is recommended that you make phone numbers clickable as more and more people would be accessing your sites on their mobile devices.
You know, How to Insert Clickable Mobile Numbers in Web Pages
We are using the simple tel protocol to convert a plain text mobile number on a web page into a clickable telephone link.
google.jpg
For instance, if you click this link on a cell phone, This will open the mobile dialer prefilled with the specified phone number. There’s no need to copy-paste numbers.
How to Type Phone Numbers in a Google Sheet.
It is a little tricky to type mobile numbers inside the Google Spreadsheets. Here’s why:
Cell numbers are mostly made of digits preceded with the plus (+) symbol. The problem is as soon as adding the plus sign in the spreadsheet cell, it assumes that you entering a math formula and tries to calculate the value.
There are two simple workarounds for this type of problem. You can enclose the mobile number inside double quotes (“) and precede it with an equal to (=) sign.
Also, An easier alternative is to use the single quote (‘) before the Mobile number. Google Sheets will then interpret the cell’s value as text and the phone number formatting will be preserved.
How to Make Phone Numbers Clickable in Google Sheets.

Know we are Coming to the main problem, How do you make phone numbers inside a Google Sheet Clickable. The obvious answer would be to use the =HYPERLINK() method with the tel protocol, But unfortunately, Google Sheets do not support this types.
dailer.jpg
So a formula here like =HYPERLINK(“tel:12345”, “Call Me”) would not work since sheets will only allow regular HTTP and mail to hyperlinks. There’s a simple workaround, though.
You can create a regular hyperlink in the cell pointing to a website which in turn redirects to the original telephone link. To see it is in action, add https://ctrlq.org/call/ before any phone number in the Google Sheet and it will be turned into the clickable telephone link.
Say you have the phone number in cell A1. Add this simple formula in any other cell and it will create a telephone link just like on a regular web page.
=HYPERLINK(“https://ctrlq.org/call/”&A1; “Call our support team”)


Also, see :

I hope you have understood How to Make Phone Numbers Callable in Google Sheets. If you like this free feel to share others

Post a Comment

0 Comments