Formula Library

Excel Formula To Get Website Host From Url

Get website host URL with a ready-to-use formula for Excel, Google Sheets, and WPS.

Quick answer

Get website host URL.

Unified formula

ExcelWPS
=LET(url, A2, TEXTBEFORE(TEXTAFTER(url, "//"), "/"))
View platform differences

Google Sheets

=REGEXEXTRACT(A2, "https?://([^/]+)")

How it works

Need a custom version?

Related formulas