How to Combine Text and Hyperlink in Excel Cell (4 Simple Ways)

Hyperlink in Excel is used to create a link to a specific 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. In this article, I will demonstrate some methods in detail to combine text and hyperlinks in Excel cells.

How to Combine Text and Hyperlink in Excel Cell: 4 Simple Ways

Before jumping into the methods, let’s learn about the dataset for this article. Here, I have taken the following dataset for this article. It contains some texts for web pages or documents. I will combine text and hyperlink in Excel cell for these texts.

1. Use Insert Hyperlink Dialogue Box to Combine Text and Hyperlink in Excel

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 hyperlink and text in the adjacent Excel cell. I will use the Insert Hyperlink dialog box for this method. Let’s see the steps.

Steps:

Firstly, create a column for Hyperlink.
Secondly, fill the cells of the column with the text you want. Here, I wrote, “Click Here!”.

Thirdly, select a cell where you want to combine text and hyperlink. Here, I selected Cell C5.
Then, go to the Insert tab.
After that, select Link.

Next, the Insert Hyperlink dialog box will appear.
Select Existing File or Web Page in the Link to section.
Then, copy and paste the link for the web page as the Address.
Afterward, select OK.

Now, you will see that you have combined a hyperlink to the selected text.

Next, I will combine hyperlink and text for another Excel workbook from this computer.
Select the cell where you want to combine the hyperlink with text.
Then, go to the Insert tab.
Afterward, select Link.

Consequently, the Insert Hyperlink dialog box will appear.
Select Existing File or Web Page in the Link to section.
After that, select Browse for File.

Now, another dialog box will appear.
Select the file you want to link to.
Then, select OK.

Next, select OK in the Insert Hyperlink dialog box.

Here, you can see that a hyperlink is combined with the text.

After that, combine text and hyperlink for the other cells.

Now, to check if it is working click on a link. Here, I clicked on the link in Cell C4.

Finally, you can see that the web page has opened for the selected text.

Read More: How to Create a Hyperlink in Excel

2. Apply HYPERLINK Function to Combine Text and Hyperlink in Excel Cell

You can easily combine the hyperlink with text in an Excel cell using the HYPERLINK function. The syntax for the HYPERLINK function is:

=Hyperlink(link_location,[friendly_name])

Here, I have taken the following dataset for this example. It has 3 columns, Text, Hyperlink, and Text & Hyperlink. I will combine the text and hyperlink in the 3rd column.

Let me show you the steps.

Steps:

To begin with, select the cell where you want to combine the Text and Hyperlink.
Then, write the following formula in that selected cell.

=HYPERLINK(C5,B5)

After that, press Enter to get the result.

Here, in the HYPERLINK function, I selected Cell C5 as link_location, and Cell B5 as friendly_name. The formula will combine the text with the hyperlink.

Next, drag the Fill Handle down to copy the formula to the other cells.

In the end, you can see that I have combined text and hyperlinks for all the other cells.

Read More: Excel Hyperlink with Shortcut Key

3. Combine HYPERLINK and CONCATENATE Functions to Join Text and Hyperlink in Excel Cell

You can also use HYPERLINK and CONCATENATE functions to combine text and hyperlink in a cell in Excel. For this example, I have taken the following dataset. It contains the names of some websites and their links. I will use the HYPERLINK function and the CONCATENATE function to join the names and link together.

Let’s see the steps.

Steps:

Firstly, select the cell where you want to combine the text and hyperlink. Here, I selected Cell D5.
Secondly, in Cell D5 write the following formula.

=HYPERLINK(C5,CONCATENATE(B5," Link: ",C5))

Thirdly, press Enter to get the output.

🔎 How Does the Formula Work?

CONCATENATE(B5,” Link: “,C5): Here, in the CONCATENATE function, I selected Cell B5 as text1, ” LInk: ” as text2, and Cell C5 as text3. The formula will join these 3 texts.
HYPERLINK(C5,CONCATENATE(B5,” Link: “,C5)): Now, in the HYPERLINK function, I selected Cell C5 as link_location, and CONCATENATE(B5,” Link: “,C5) as fiendly_name. The formula will combine the text and hyperlink and then jump into the selected location when you click on it.

Next, drag the Fill Handle down to copy the formula to the other cells.

Finally, you can see that I have copied the formula to all the other cells and got my desired results.

4. Employ Ampersand with HYPERLINK Function to Merge Text and Hyperlink in Excel Cell

The Ampersand operator (&) is used to join texts in Excel. You can use it with the HYPERLINK function to combine text and hyperlink in Excel cell. Let me show you the steps.

Steps:

To begin with, select the cell where you want to join the text with a hyperlink.
Next, write the following formula in that selected cell.

=HYPERLINK(C5,"For "&B5&" Click "&"Here")

After that, press Enter to get the result.

🔎 How Does the Formula Work?

“For “&B5&” Click “&”Here”: Here, the Ampersand operator (&) joins these texts.
HYPERLINK(C5,”For “&B5&” Click “&”Here”): Now, in the HYPERLINK function, I selected Cell C5 as link_location, and “For “&B5&” Click “&”Here” as fiendly_name. The formula combines the text and hyperlink and then jumps into the selected location when you click on it.

Next, drag the Fill Handle down to copy the formula to the other cells.

Finally, you can see that I have copied the formula to all the other cells and got my desired results.

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.

Practice Section

Here, I have provided a practice sheet for you to practice how to combine text and hyperlink in an Excel cell.

Download Practice Workbook

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

Combining Text and Hyperlink.xlsx

Conclusion

Today, I discussed 4 simple 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.

How to Combine Text and Hyperlink in Excel Cell (4 Simple Ways)

How to Combine Text and Hyperlink in Excel Cell: 4 Simple Ways

1. Use Insert Hyperlink Dialogue Box to Combine Text and Hyperlink in Excel

2. Apply HYPERLINK Function to Combine Text and Hyperlink in Excel Cell

3. Combine HYPERLINK and CONCATENATE Functions to Join Text and Hyperlink in Excel Cell

4. Employ Ampersand with HYPERLINK Function to Merge Text and Hyperlink in Excel Cell

Things to Remember

Practice Section

Conclusion

Similar Articles for You to Explore

Leave a reply Cancel reply