Extract URL Links From Hyperlinks or To Convert Plain Text Links to Hyperlinks in Excel!!
Tags: extracturllinksfromh, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:32:05

---
title: Extract URL Links From Hyperlinks or To Convert Plain Text Links to Hyperlinks in Excel!!
published: true
date: 2020-11-16 06:42:28 UTC
tags: ExtractURLLinksfromH,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/extract-url-links-from-hyperlinks-or-to-convert-plain-text-links-to-hyperlinks-in-excel/
---

In this article, you will learn the steps to know how to **Extract URL Links from Hyperlinks or To Convert Plain Text Links to Hyperlinks** in **Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Extract URL Links from Multiple Hyperlinks:

Here are the steps to extract URL (Uniform Resource Locator) links from multiple hyperlinks. Do as below steps.

- If you have a **range of hyperlinks** in your spreadsheet as shown in the below screenshot, you can easily extract the URL links from that.
- You need to **select the input range**.

![Example range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-range.png)<figcaption id="caption-attachment-17318">Example range</figcaption>

- Go to the **Kutools Tab, select** the **Link** option, then **choose** the **Convert Hyperlinks** option.

![Select the Convert Hyperlinks option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Convert-Hyperlinks-option.png)<figcaption id="caption-attachment-17319">Select the Convert Hyperlinks option</figcaption>

- Now, it will display the **Convert Hyperlinks Dialog Box**.
- **Convert type –** You need to **choose** the **Hyperlinks addresses replace cell contents** option.
- **Input range –** Here, you need to **select the range** that you want to apply the operation using the given browse button.
- **Result range (single cell) – Select**  **a**  **cell** to display the result.
- If you don’t want to print the results into a new range, you need to **check** the **Convert source range** option. This is an optional one.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-9.png)<figcaption id="caption-attachment-17320">Click the OK button</figcaption>

- Finally, **hit** the **OK** button to see the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-7.png)<figcaption id="caption-attachment-17321">Output</figcaption>

## Convert Plain Text Links to Hyperlinks:

To convert plain text links to hyperlinks in the Excel worksheet, follow the below steps.

- Let’s consider the **example text URLs** as shown in the below image.
- We are going to **convert it to hyperlinks** by doing the below instructions.
- First, you need to **select the range** that you want to convert.

![select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-20.png)<figcaption id="caption-attachment-17322">select the range</figcaption>

- Go to the **Kutools Tab,** select the **Link** option, then **choose** the **Convert Hyperlinks** option.

![Select the Convert Hyperlinks option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Convert-Hyperlinks-option.png)<figcaption id="caption-attachment-17319">Select the Convert Hyperlinks option</figcaption>

- It will open the **Convert Hyperlinks Dialog Box**.
- **Convert type – ** You need to **select** the **Cell contents replace hyperlinks addresses** option.
- **Input range –** Here, you need to **select the range** that you want to apply the operation using the given browse button.
- **Result range (single cell) – Select**  **a**  **cell** to display the result.
- If you don’t want to print the results into a new range, you need to **check** the **Convert source range** option. This is an optional one.
- **Convert source range –** If the hyperlink is linked to the current document, check this option.

![Convert Hyperlinks Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-16.png)<figcaption id="caption-attachment-17324">Convert Hyperlinks Dialog Box</figcaption>

- Finally, **click** the **OK** button to apply the operation and get the output as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-19.png)<figcaption id="caption-attachment-17323">Output</figcaption>

## A Short Synopsis:

In the above article, you can clearly learn the steps to **Extract URL Links from Hyperlinks or To Convert Plain Text Links to Hyperlinks** in **Excel Office 365** using **Kutools. ** leave your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [How to Format a Text/Number as a Subscript in Excel 365?](https://geekexcel.com/how-to-format-a-text-number-as-a-subscript-in-excel-365/)
- [Formulas to Count Cells Contains Equal Values or Numbers in Excel!!](https://geekexcel.com/formulas-to-count-cells-contains-equal-values-or-numbers-in-excel/)