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! 💃
Table of Contents
Hover Over Cell to Remove Hyperlinks
- 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.
- 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.
Using Right-Click to Remove Hyperlinks
- Simply select the range of cells that you want to remove the hyperlink at. In this example, it will be A1:A3.
- Right-click on the selected cells. An options bar would appear. Then select ‘Remove link‘.
- Once you click on ‘Remove link‘, the cells will no longer be a hyperlinked text.
Using Paste Special to Remove Hyperlinks
- Select the cell you would like to paste the values at. In this example, it would be A1.
- Instead of directly pasting the hyperlink values by pressing the keyboard shortcut CTRL+V, right–click 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.
- Click ‘Paste values only‘. This would enable us to paste only the cell value.
- We can also press CTRL+Shift+V on the keyboard to only paste the value. This is a keyboard shortcut.
Using a Formula to Remove Hyperlinks
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.
- Select the cell you would like to input the formula in, in this example, it would be B1.
- Begin your function with an equal sign
=, then followed by a quote-unquote symbol
""into the formula.
- Next, we will insert an ampersand
&symbol to join two or more text strings in a single string.
- Lastly, we will select the text you want to remove the hyperlink from. In this example, it will be A1. Then press Enter.
- After the following steps, your input should look like this:
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.