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

Get FREE Advanced Excel Exercises with Solutions!

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 hyperlink in Excel cell.


Download Practice Workbook

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


4 Simple Ways to Combine Text and Hyperlink in Excel Cell

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.

Dataset to Combine Text and Hyperlink in Excel Cell


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

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

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

Using LInk Command to Combine Text and Hyperlink in Excel Cells

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

Inserting Link from Computer to Combine Text and Hyperlink in Excel

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


Similar Readings:


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.

Apply 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 combine the Text and Hyperlink.
  • Then, write the following formula in that selected cell.
=HYPERLINK(C5,B5)

Insering Formula to Combine Text and Hyperlink in Excel Cell

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

Dragging Fill Handle down to Copy Formula to Combine Text and Hyperlink in Excel Cell

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


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.

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

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")

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

  • 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 Excel cell.

Practice Sheet to Combine Text and Hyperlink in Excel Cell


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.


Similar Articles for You to Explore

Asikul Himel
Asikul Himel

Hi! I am Asikul Islam Himel. Glad you are here. I am a Team Leader of ExcelDemy, running an excellent team of five efficient Excel & VBA Content Developers. Here at ExcelDemy, we give the best sustainable solutions by posting articles related to MS Excel-related problems. I have completed my under graduation degree from Bangladesh University of Engineering and Technology and my program was Naval Architecture and Marine Engineering. I have found passion in data analysis and research-based fields. I am currently working to grow my leadership quality. I have a great interest in project management and critical thinking. In my free time, I love to travel and read books.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo