Use this formula to extract a root domain from a long URL in Google Sheets:

=REGEXREPLACE(REGEXEXTRACT(B2, "https?://(.*?)/"), "^www\.", "")

This will come in handy when you’re trying to organize a list of link prospects.

Here’s the ChatGPT prompt I used:

And the output:

Just double-click on the cell, update the range, and hit enter to extract the domain:

SEO Bite #4: Use ChatGPT to help you create, fix, or optimize formulas for Google Sheets to scale your SEO efforts.