Extract domain URL from a link 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 domain URL from a link in Excel

How to extract a domain URL from a link in Excel?
Extract domain URL from a link in Excel

EXTRACT DOMAIN URL FROM A LINK — EXCEL FORMULA AND EXAMPLE

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

Extract domain URL from a link in Google Sheets

How to extract a domain URL from a link in Google Sheets?
Extract domain URL from a link in Google Sheets

EXTRACT DOMAIN URL FROM A LINK — GOOGLE SHEETS FORMULA AND EXAMPLE

=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