How to Combine Text And Hyperlink in Excel Cell (2 Methods)

Using the standard HYPERLINK Function to combine text and hyperlink

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.

Quick View

Using the standard HYPERLINK Function to combine text and hyperlink

Download Practice Workbook

Download this practice sheet to practice while you are reading this article.

Combine Text And Hyperlink in Excel Cell (2 Methods)

In this section, we will discuss two different approaches to combine text and hyperlink in Excel cells.

1. Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Step-1:

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”.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Step-2:

To start this task, select cell C4, then go to Insert and click on Hyperlink.

C4→Insert→Hyperlink

Using the Insert Hyperlink Dialogue Box to Combine Text And 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.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

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.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Step-3:

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 Using the standard HYPERLINK Function to combine text and hyperlink  to browse files.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Step-4:

Go to the location where the workbook is located. Select the Excel file and click on Ok to continue.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Now the final address is shown in the address bar. Confirm it by clicking Ok.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

And our workbook is also linked to a single text. You can use the same procedure to link any folder or picture too.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Step-5:

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.

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

Now, let’s check the hyperlink by clicking on it. Click on the text in cell C4 and the result shows as below,

Using the Insert Hyperlink Dialogue Box to Combine Text And Hyperlink

2. Using the HYPERLINK Function to Combine Text And Hyperlink

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

Step-1:

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.

Using the standard HYPERLINK Function to combine text and hyperlink

Step-2:

In cell D4 of the Text & Hyperlink column, Apply the HYPERLINK function. The generic HYPERLINK function is,

=Hyperlink(link_location,[friendly_name])

Insert the values into the function and the final form of the function is,

=HYPERLINK(C4,B4)

Where,

  • Link_location is the path of the web page or file to be opened (C4)
  • [friendly_name] is the hyperlink text to display (B4)

 

Using the standard HYPERLINK Function to combine text and hyperlink

Press “Enter” to apply the function.

Using the standard HYPERLINK Function to combine text and hyperlink

Step-3:

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,

Using the standard HYPERLINK Function to combine text and hyperlink

ii. Using the HYPERLINK with the CONCATENATE Function

Step-1:

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,

=HYPERLINK(C4,CONCATENATE(B4,C4))

Where,

  • Link_location is (C4)
  • [friendly_name] is CONCATENATE(B4,C4). The CONCATENATE function will join B4 and C4 in a single text.

Using the HYPERLINK with the CONCATENATE Function to combine text and hyperlink

Get the result by pressing Enter.

Using the HYPERLINK with the CONCATENATE Function to combine text and hyperlink

Step-2:

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.

Using the HYPERLINK with the CONCATENATE Function to combine text and hyperlink

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.

Conclusion

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.

Similar Articles for You to Explore

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo