How to Extract A Domain From A URL In Google Sheets
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: http://bit.ly/ytbananasagency
Great Google Sheets Tips: http://bit.ly/bencollinsgsheets