How to Make Phone Numbers Callable in Google Sheets?

How to Insert Clickable Phone Numbers in Web Pages

We use the simple tel protocol to convert a plain text phone number on a web page into a clickable telephone link

For instance, if you click this link on a mobile phone, it will open the phone dialer prefilled with the specified number. There’s no need to copy-paste numbers.

How to Type Phone Numbers in a Google Sheet

It is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why:

Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon as add 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 to this problem. You can enclose the phone number inside double quotes (“) and precede it with an equal to (=) sign.

An even easier alternative is to use the single quote (‘) before the phone 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

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 it.

So a formula like =HYPERLINK(“tel:12345”, “Call Me”) would not work since sheets will only allow regular http and mailto 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 actual telephone link. To see this in action, add https://ctrlq.org/call/ before any phone number in the Google Sheet and it will turn into a 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 webpage.

=HYPERLINK(“https://ctrlq.org/call/”&A1; “Call our support team”)

Comments

5 real-world events which ‘prove’ that time travel actually exists

In Back to the Future, you need an expensive car, and a conveniently placed lightning bolt – but what if time travel was easier than that? What if time travellers were ALL AROUND US? The ‘time travelling hipster’ (above) is one of the creepier pieces of evidence touted as proof that time travel exists – but we’ve picked out some of the best below, including several people from black-and-white films who appear to be using mobile phones. Nigel Watson, paranormal expert and author of the UFO Investigations Manual, ‘Would time travelers from the future really be using mobile phones? Wouldn’t they use something more sophisticated and less visible? Then again Dr Who still uses a sonic screwdriver and that is so 20th Century…’ Entry by Cervus Entry by Chan Teik Onn Entry by GordonHaid Entry by gicusudoru

Anonymous just declared war against Donald Trump !@

One of the primary Twitter accounts for the internet’s most notorious hacktivist collective tweeted multiple times at the President-elect on Sunday night, shortly after Trump attacked civil rights icon John Lewis and blasted Saturday Night Live as “ the worst of NBC ” (oddly enough the same network that carries the reality TV show for which Trump is listed as an executive producer ) . In a series of responses to one of Trump’s tweets accusing outgoing CIA director John Brennan of leaking the infamous “Golden Showers” dossier, @YourAnonCentral told the President-elect that his dealings with “Russian mobsters, child traffickers, and money launderers” would soon come to light. Anonymous also ominously warned Trump that information on the internet is there forever, and that his rich father can’t protect him anymore. Anonymous isn’t just blowing hot air — Trump actually does have ties to unsavory characters tied to the Russia mob, according to Pulitze...

10 MOST HAUNTED PLACES IN THE WORLD

It seems that one of the most enduring aspects of cultural similarity found throughout the world involves the supernatural. No matter where you go across the globe, you’re going to hear various legends and ghost stories…except some of these carry significantly more weight than your average campfire story. People seem to be somewhat obsessed with what goes on after death, especially in regards to whether or not the spirits of the departed stick around. It would be easy to say that such attention can be blamed on vivid, Hollywood inspired imaginations, but documented reports of supernatural disturbances go back several centuries in many places, underlining the fact that no matter the time period or society involved, the paranormal remains on people’s minds. Sure, many places in the world that are reputedly haunted seem more far-fetched than realistic, but there are those that have a tendency to make even the most hardened skeptic stop and reconsider. Listed he...

Digital Inspiration

Search This Blog