Strip URL to Root Domain - Excel & Google Sheets Formula

Sitebee

Freelance Technical SEO
Staff member
If you are working with large lists of URLs that you need to strip down to the domain root, when this nifty formula might just be the trick you're looking for.

Code:
=LEFT(A2,FIND("/",A2,9))

Instructions:
1, Paste the list of full URLs in Column A, line 2