• Skip to primary navigation
  • Skip to main content
  • Skip to footer
TechLila

TechLila

Bleeding Edge, Always

  • Home
  • About
  • Contact
  • Advertise
  • Deals and Offers
Techlila
Share
Tweet
Share
Pin
58 Shares
Best VPN for Kodi
Up Next

Best VPN for Kodi

How to Make Phone Numbers Callable in Google Sheets

TechLila Internet

How to Make Phone Numbers Callable in Google Sheets

Avatar for John Hannah John Hannah
Last updated on: December 15, 2019

Google’s foray into Office tools such as Spreadsheet and Docs made things easy and work-on-the-go. But as with Google, many of the features went pretty undiscovered.

One of these features include in Google Spreadsheet – How to Make Phone Numbers Callable in Google Sheets?

Some of you might not even venture into this line of thought, but it’s always better to be a step ahead. You never know when it will come in handy and don’t know how to proceed when such a scenario comes.

Before you proceed to Google phone numbers to be attached to Google spreadsheets, what is meant by ‘Callable’?

You must have seen ‘Contact Us’ pages on the various website which provides you an email-ID to contact. Mostly, they provide the feature which leads you directly to your email client to address them an email.

On the same lines, nowadays phone numbers are being added to pages so that you can directly call them and get to know the details. Retail stores and food outlets are following this scheme pretty religiously.

Moreover, with the penetration of mobile phones in more and more household, people now can connect with stores and other places directly from home, one of them being through directly calling them.

How are Phone Numbers Added in Web Pages?

Phone numbers can be easily added to web pages by just following the HTML protocol.

Callable Phone Numbers

By following the above scheme, you can easily add Google phone numbers.

How to Insert Google Phone Numbers in Google Sheets

Unlike web pages, it’s very tricky to add Google phone numbers to Google Sheets.

Because most of the phone numbers starting with a (+) sign (international codes), Google Sheets treats it as a math formula and in turn, tries to calculate the value. Which, returns an error.

To resolve this error, you can do this:

Make Phone Number Callable
  • Enclose it in double quotes (“) and precede it with an equal-to sign (=)
  • Or simply, precede the entire number with a single quote (‘)

How to Make Numbers Callable in Google Sheets?

Even though we successfully typed the numbers into the Sheets, the numbers displayed aren’t clickable. They are only displayed.

One solution would be using the HYPERLINK() protocol. Along with the tel protocol, theoretically, it should do the job easily.

But the HYPERLINK() protocol only supports mailto and the regular http protocols. Meaning, you can only link it to email addresses and website addresses.

The simple solution would be to direct the link to any website which would, in turn, redirect to the actual telephone number.

Suppose you have the phone number in cell ‘A1’, just follow these scheme:

=HYPERLINK(“https://techlila.com/call/”&A1; “Call”)

Hyperlink Number

The final result would come like this:

Callable Google Phone Numbers

That’s it! It’s really so easy to add.

Let us know if you have some doubts or concerns and we would help you as soon as possible.

Share
Tweet
Share
Pin
58 Shares

Sharing is Caring

Share
Tweet
Share
Pin
58 Shares
Avatar for John Hannah

John Hannah

John Hannah is a part-time blogger. He likes to travel a lot.

Category

  • Internet

Tags

Google, Google Drive

Reader Interactions

What people are saying

  1. Avatar for MilindMilind

    Hi John, I really appreciate your article and way of representation. Keep working. Good luck!

    Reply
    • Avatar for Mahesh DabadeMahesh Dabade

      Thanks Milind :)

      Reply
  2. Avatar for BenjaminBenjamin

    Nice one mark
    This is another new tip to work on.

    Reply

Add Your Comment Cancel reply

Your email address will not be published. Required fields are marked *

Footer Logo Footer Text Logo

Footer

About

Hello and welcome to TechLila, the famous technology blog where you can find resourceful articles for mastering the basics and beyond.

At TechLila, our main goal is to provide unique information, such as quality tips and tricks, tutorials, how-to guides on Windows, Macintosh, Linux, Android, iPhone, Security and a few miscellaneous sub-topics such as reviews.

Links

  • About
  • Contact Us
  • Disclaimer
  • Privacy Policy
  • Terms

Follow

Custom Theme Using Genesis Framework

Cloud hosting by Cloudways

© Copyright  2012–2021 TechLila. All Rights Reserved.