Table of Contents
The process of extracting a URL from a hyperlink in Excel involves using the “Edit Hyperlink” function to access the hyperlink’s underlying URL. This can be done by right-clicking on the hyperlink and selecting “Edit Hyperlink” from the drop-down menu. The URL can then be copied and used for various purposes, such as linking to a specific webpage or referencing it in a formula. This feature is useful for efficiently managing and organizing data in Excel.
Excel: Extract URL from Hyperlink
You can use the TEXT function in Excel to extract a URL from a hyperlink.
For example, you can use the following formula to extract the URL from the hyperlink in cell A2:
=TEXT(A2, "")
The following example shows how to use this syntax in practice.
Example: Extract URL from Hyperlink in Excel
Suppose we have the following column of hyperlinks in Excel:
If we click on any of these hyperlinks, we will automatically be taken to the URL that the hyperlink points to.
Suppose we would instead like to extract the URL from each hyperlink as text.
We can type the following formula into cell B2 to do so:
=TEXT(A2, "")
We can then click and drag this formula down to each remaining cell in column B:
Column B now contains only the URL from each hyperlink in column A.
If we click on any of the URL’s in column B, we will not automatically be redirected to the the web page in a web browser.
How This Formula Works
Recall the formula that we used to extract the URL from the hyperlink in cell A2:
=TEXT(A2, "")
This formula uses the TEXT function, which uses the following basic syntax:
TEXT(Value you want to format, “Format code to apply”)
By using the formula TEXT(A2, “”) we tell Excel that we’d like to get the value in cell A2 and apply no format to it.
This results in just the text from cell A2 by itself.
Note: You can find the complete documentation for the TEXT function in Excel .
Additional Resources
The following tutorials explain how to perform other common operations in Excel: