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