ciaranmahoney/Extract naked domain from full url

Created August 18, 2016 21:59

Star (3) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ciaranmahoney/046a6c1cfd9e12eb37a9adea34a5e7df.js"></script>
Save ciaranmahoney/046a6c1cfd9e12eb37a9adea34a5e7df to your computer and use it in GitHub Desktop.

Download ZIP

Formula for extracting naked domain from full url in Google Sheets.

Raw

Extract naked domain from full url

=iferror(trim(REGEXEXTRACT(REGEXREPLACE(REGEXREPLACE(A2,"https?://",""),"^(w{3}\.)?","")&"/","([^/?]+)")))

ihorkit commented Nov 11, 2018

thanks for the formula. how would you extract subdomains e.g. "sub.example.com" to "example.com"?

muthali commented Sep 10, 2020 •

edited

Loading

I was able to get a formula of my own that works with subdomains as well. I have written about it here universal URL to domain google sheets.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment