Guides
How to get links out of the places they hide — and what each method cannot do. Every code example and formula here was run against the environment named alongside it.
Excel and Google Sheets techniques for hyperlinks and URL text.
- Spreadsheets
How to Extract URLs and Domains from Text in Google Sheets
Formulas that pull addresses out of a text column, get the hostname, and — importantly — why the popular "root domain" formula is wrong for half the internet.
Read the guide - Spreadsheets
How to Extract Hyperlink URLs in Google Sheets
Google Sheets has two kinds of hyperlink too. One yields to a formula; the other needs Apps Script, because no formula can see it. Here is how to tell which you have.
Read the guide - Spreadsheets
How to Extract URLs from Hyperlinks in Excel
A cell showing "Click here" stores its address somewhere you cannot reach with a formula. Three methods that work — VBA, FORMULATEXT and unzipping the file — and exactly when each one applies.
Read the guide