How to Remove Hyperlinks in Google Sheets

Removing hyperlinks is useful when you want to remove texts automatically recognized by Google Sheets as hyperlinks.

First, what are hyperlinks, you may ask? Hyperlinks are basically a link to another location, activated by clicking on a highlighted word or image.

Do check out the tutorial for HYPERLINK function to learn how to display hyperlinks in a more visually appealing way!

Hyperlinks can be handy, however, it gets unnecessary and irritating when it serves no purpose. In this guide, we will demonstrate four ways to remove hyperlinks from your Google Sheet. Let’s get straight into it! 💃

 

 

  1. Hover over the cell you want to remove the hyperlink from. In our case, A1. When you hover over A1, a hyperlink would show to let you click on it which would redirect you to that site. Let’s remove that.

How to Remove Hyperlinks in Google Sheets

 

  1. Click on the third icon, which is to remove the hyperlink from the text.

 

Simple! Let’s learn how to remove hyperlinks from several cells instead of just one cell. 

 

 

  1. Simply select the range of cells that you want to remove the hyperlink at. In this example, it will be A1:A3

 

  1. Right-click on the selected cells. An options bar would appear. Then select ‘Remove link.

 

  1. Once you click on ‘Remove link, the cells will no longer be a hyperlinked text.

 

 

  1. Select the cell you would like to paste the values at. In this example, it would be A1.

 

  1. Instead of directly pasting the hyperlink values by pressing the keyboard shortcut CTRL+V, rightclick the cell. An options bar would appear. Click on ‘Paste special. It would open another dropdown for you to select what methods you want to paste your values in.

How to Remove Hyperlinks in Google Sheets

 

 

  1. Click ‘Paste values only. This would enable us to paste only the cell value.

 

  1. We can also press CTRL+Shift+V on the keyboard to only paste the value. This is a keyboard shortcut.

 

 

There are no direct functions in Google Sheet that enable the return value to remove its hyperlinks. However, by using this simple formula, we can change the hyperlinked text into a regular text. 

Using a formula is also more convenient as when the data changes, your return values change. You do not need to remove the hyperlinks all over again.

 

  1. Select the cell you would like to input the formula in, in this example, it would be B1.

 

  1. Begin your function with an equal sign =, then followed by a quote-unquote symbol "" into the formula.

 

  1. Next, we will insert an ampersand & symbol to join two or more text strings in a single string.

How to Remove Hyperlinks in Google Sheets

 

  1. Lastly, we will select the text you want to remove the hyperlink from. In this example, it will be A1. Then press Enter.

How to Remove Hyperlinks in Google Sheets

 

  1. After the following steps, your input should look like this:

How to Remove Hyperlinks in Google Sheets

 

What the formula does, is that it concatenates (joins) the text in cell A1, with a blank character.  By doing so, the formula converts the text in A1 to regular text. 

Wonderful! Now you have learned four different ways to remove hyperlinks from your Google Sheets. 🎈

You can now use this newfound skill together with the other numerous Google Sheets formulas to create even more powerful formulas that can make your life much easier.

 

Get emails from us about Google Sheets.

Our goal this year is to create lots of rich, bite-sized tutorials for Google Sheets users like you. If you liked this one, you'll love what we are working on! Readers receive ✨ early access ✨ to new content.

 
0 Shares:
Leave a Reply

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

You May Also Like