How to Convert Text to Hyperlink in Excel

Effortlessly navigate to and fro to websites by converting texts to hyperlinks!

Hyperlinks facilitate seamless access to external resources or websites. Similarly, you can convert text to hyperlinks in Excel to create interactive dashboards, reference sheets, or collaborative documents.

Unsure how to do so? In this guide, we will walk you through every step to create an interactive sheet.

How to Convert Text to Hyperlink in Excel

How to Convert Text to Hyperlink in Excel

Follow the steps to convert text to Hyperlink:

1. Open Excel and place your link and text next to each other.

2. Type =HYPERLINK and select the formula from the drop-down menu in the third cell, as shown below.

3. Now, double-click on the link, insert a comma in the formula, double-click on the text, and hit the Enter key

put a comma in the formula and double click on the text

Also Read: How to Clear Formatting in Excel Using Shortcut

How to Insert Hyperlink in Excel Cell with Other Text or Convert Multiple Text to Hyperlink in Excel

The steps to convert multiple texts to hyperlinks in Excel are the same as shown above. Remember, it is only possible to link one text to a hyperlink in a single cell with the method mentioned above. However, if you wish to convert multiple texts to hyperlinks in the same cell, follow our guide on How to Hyperlink on Excel in 5 Ways to do the same.

How to Combine Text and Hyperlink in Excel

There are different ways to combine text and hyperlinks in Excel. Let’s check them out.

Method 1: Using Insert Hyperlink Dialog Box

The easiest way to combine cells with text and hyperlinks in Excel is by using the insert hyperlink dialog box. Follow the steps mentioned below:

1. Select the cell with the text to combine. 

2. Under the Insert tab, select Link.

3. Paste the link in the Insert link dialogue box and click on OK.

Paste the link

Method 2: With Hyperlink Function

Follow the steps under How to Convert Text to Hyperlink in Excel mentioned above to use the Hyperlink Function to combine your texts and links in an Excel workbook.

Also Read: 10 Functions of MS Excel that Everyone Should Know

Method 3: Using Ampersand and Hyperlink Function

Follow the steps mentioned below to combine text and hyperlinks in Excel using ampersand (&) and hyperlink function:

1. Select the cell with text to combine.

2. Write =HYPERLINK(_,”For “&_&” Click “&”Here”) and press the Enter key.

For example: =HYPERLINK(B1,”For “&A1&” Click “&”Here”). Here, B1 is the cell with hyperlink and A1 is the text to combine.

Enter the formula

Method 4: Using Concatenate and Hyperlink Functions

Follow the steps mentioned below to combine columns with text and hyperlinks in Excel using concatenate and hyperlink functions:

1. Select the cell with text to combine.

2. Write =HYPERLINK(_,CONCATENATE(_,” Link: “,_)) and press the Enter key.

For example: =HYPERLINK(B1,CONCATENATE(A1,” Link: “,B1)). Here, B1 is the cell with hyperlink and A1 is the text to combine.

Enter the formula | convert text to hyperlink in excel

Also Read: How to Unprotect Excel Workbook Without Password

We hope our guide on how to combine text and hyperlink in Excel has cleared all your doubts. Keep coming back to Techcult for more tech-related walkarounds!

Leave a Comment

Your email address will not be published. Required fields are marked *