Extract URL domain root in Excel and Google Sheets

=LEFT(A2,(FIND(".com/",A2,1)+3))

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Extract URL domain root in Excel

How to extract URL domain root in Excel?
Extract URL domain root in Excel

EXTRACT URL DOMAIN ROOT — EXCEL FORMULA AND EXAMPLE

=LEFT(A2,(FIND(".com/",A2,1)+3))

Extract URL domain root in Google Sheets

How to extract URL domain root in Google Sheets?
Extract URL domain root in Google Sheets

EXTRACT URL DOMAIN ROOT — GOOGLE SHEETS FORMULA AND EXAMPLE

  1. =REGEXEXTRACT(A2,"^(?:https?://)?(?:[^@\n]+@)?(?:www\.)?[^:/\n?]+")

  2. =LEFT(A2,(FIND(".com/",A2,1)+3))

Other useful extract formulas in Excel and Google Sheets explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions