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


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.

Want More SEO Bites?

Subscribe because SEO Bites are not published anywhere else.





Source link

Leave a Comment

Your email address will not be published. Required fields are marked *