Extracting Hyperlink URLs In Google Sheets

Google Sheets is a powerful tool for data management and analysis, but it can also be used for more advanced tasks such as extracting URLs from hyperlinks.

In this article, we will show you how to extract the URLs of hyperlinks in Google Sheets using a simple formula.

The HYPERLINK Function

The first step in extracting URLs from hyperlinks in Google Sheets is to use the HYPERLINK function.

This function takes two arguments: the URL of the hyperlink, and the label that will be displayed for the link.

Extracting URLs From Hyperlinks

Once you have the URL of the hyperlink, you can use the LEFT and RIGHT functions to extract the specific part of the URL that you need.

This formula uses the LEFT function to extract the characters on the left side of the “/” in the URL, and the RIGHT function to extract the characters on the right side of the “/” in the URL.

Alternatively, if you only want to extract the top-level domain of the URL (e.com), you can use the following formula:

Extracting Multiple URLs From Hyperlinks

If you have a list of hyperlinks in a column and you want to extract the URLs for all of them, you can use the HYPERLINK and LEFT/RIGHT functions in combination with the IFERROR and ARRAYFORMULA functions.

In conclusion, extracting URLs from hyperlinks in Google Sheets is a simple task that can be accomplished using the HYPERLINK, LEFT, and RIGHT functions.

Whether you need to extract a single URL or multiple URLs, these functions can be used in combination with the IFERROR and ARRAYFORMULA functions to quickly and easily extract the information you need.