SEO Bite #4 – Extract Root Domain from URL in Google Sheets

November 27, 2023

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.

The source of this news is from Gotch SEO