Hyperlink in Excel is used to create a link to a certain web page, documents, and folder or to a specific worksheet. There may be a situation when you are dealing with a large number of hyperlinks and you need to mark them with certain text. Excel provides some features and functions by which you can combine your hyperlink with a specific text. Today in this article, we will demonstrate some methods in detail to combine text and hyperlink in Excel cells.
Download Practice Workbook
Download this practice sheet to practice while you are reading this article.
In this section, we will discuss two different approaches to combine text and hyperlink in Excel cells.
Consider a situation where you have a range of text in one column. Each of the texts provides a specific hyperlink. You need to link those hyperlinks to their adjacent cell texts. That means you need to combine hyperlinks and texts in the column “Hyperlink” for each cell in the column “Link to”.
To start this task, select cell C4, then go to Insert and click on Hyperlink.
A window named Insert Hyperlink appears. In this window, select Existing File or Web Page as a link to criteria. Then in the address bar, paste the URL that you want to link to the text. Click Ok to proceed.
Now we can see that our text and hyperlink are combined in a single cell. If you click on this text, the hyperlink will take you to the required web address.
You can also link a different workbook or worksheet to a text and combine the hyperlink and text in a single cell. To do it, select a cell (C11), then open the Insert Hyperlink window. In the window, select Existing File or Web Page as a link to criteria. Then click on this icon to browse files.
Go to the location where the workbook is located. Select the Excel file and click on Ok to continue.
Now the final address is shown in the address bar. Confirm it by clicking Ok.
And our workbook is also linked to a single text. You can use the same procedure to link any folder or picture too.
Now do the same for the rest of the cells in the column. That’s how we combine the hyperlink and text in a single cell.
Now, let’s check the hyperlink by clicking on it. Click on the text in cell C4 and the result shows as below,
We can easily combine the hyperlink with a text in an Excel cell using the HYPERLINK function. There are two different ways to do it. Let’s learn both of them!
i. Using the Standard HYPERLINK Function
In the given example, some texts and their relevant article is given in the “Text” and the “Hyperlink” column. We have to add this text and its relative hyperlink to a single cell in the “Text & Hyperlink” column.
In cell D4 of the Text & Hyperlink column, Apply the HYPERLINK function. The generic HYPERLINK function is,
Insert the values into the function and the final form of the function is,
- Link_location is the path of the web page or file to be opened (C4)
- [friendly_name] is the hyperlink text to display (B4)
Press “Enter” to apply the function.
So the hyperlink and the text are combined in a single cell. If you click on the text, the webpage will open in your browser. Now do the same for the rest of the cells and the final result is,
ii. Using the HYPERLINK with the CONCATENATE Function
We will use the previous example to complete this task. In cell C4, apply the HYPERLINK function with the CONCATENATE function. Insert the formula and the final formula is,
- Link_location is (C4)
- [friendly_name] is CONCATENATE(B4,C4). The CONCATENATE function will join B4 and C4 in a single text.
Get the result by pressing Enter.
Now, If you click on the text, the webpage will open in your browser. Apply the same formula to the rest of the cells to complete the task.
Things to Remember
➤ You need to use the HYPERLINK function to create a link in the text. Only using the CONCATENATE or the Ampersand (&) won’t be able to create the hyperlink in the text.
Today we discussed two methods to combine text and hyperlink in a single cell in Excel. If you have any confusion or suggestions, you are most welcome to share your thoughts in the comment section.