In this video, we show you how to extract the root domain of a URL using Google Sheets.

Extract the root domain from the URL string using the RegExtract script:

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

Replace"C2" with the correct cell number of the first URL.

LINKS
Agency Website: [ Ссылка ]
Great Google Sheets Tips: [ Ссылка ]

свернуть