How to Create URL to SMS a Phone Number in Messages from Google Sheets
Learn how to create a URL that allows you to send SMS messages directly from Google Sheets by formatting phone numbers correctly. This tutorial covers the use of the HYPERLINK function and how to handle common formatting issues.
We're going to create a URL. Or actually, some text that mimics an SMS so much that we can copy paste this SMS text into Chrome and it will open messages to text people. So how do we do this? With a phone number , we're, start with either a general phone number without any formatting or even a plus sign, totally okay. We're going to equals hyperlink . We're going to add SMS, SMS, colon, and we're going to use an ampersand here and select the range with the phone number in it. There we can copy paste this all the way down. Even the numbers that don't have a plus sign, they will work, they will open messages, and you'll be able to message someone. If, however, your phone number doesn't look formatted in a different way, or even if you're copy pasting phone numbers into Google Sheets and you're getting Create Hundreds of Tweets in a Google Sheet ChatGPT Clone in Google Sheets Embed a Number in a Website from a Google Sheet How to Fix Phone Number Formula Parse Errors in Google Sheets
some errors, this is what's going on. www. microsoft. com This plus sign, if you have it, is going to create a formula . Google Sheets essentially thinks that this is a addition. It doesn't know that it's a, uh, phone number . So how do we get this equal sign, or even sometimes you might have a formula parse error . How do we get it into a plus sign? We're going to Command F. Click this three buttons to get more options. We're going to find every equal sign and replace it with a plus sign. We're going to select a specific range , and the key here is to also search within formulas. Click that, replace all , and done, and there you go. You have formatted number with a plus sign. You can do this manually. If you just have a plus sign here, you can see this equal sign. Just take this equal sign, add a quote, add a plus, and there you go. Google Sheet Basics - The Absolute Basics Your First Formula in Google Sheets How to Fix Phone Number Formula Parse Errors in Google Sheets
Or you can even get rid of the plus sign and the quote, and just have the phone number As numbers only. And this way you have an SMS link. You can copy paste this anywhere into Chrome. It'll open messages or even any app that you select to send text messages. If you're looking to get more out of your Google sheets than you ever have before, consider subscribing here on YouTube to better sheets. Send a Button from Google Sheets in an Email Extract URLs from Google Sheets Embed a Number in a Website from a Google Sheet How to Fix Phone Number Formula Parse Errors in Google Sheets