公式库

Excel Formula To Get Root Domain From Web Address

Get root domain web address with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Get root domain web address.

统一公式

ExcelWPS
=LET(url, A2, TEXTBEFORE(TEXTAFTER(url, "//"), "/"))
查看平台差异

Google Sheets

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

使用说明

需要定制版本？

相关公式

Excel Formula To Extract Domain From A Url

Extract domain a URL with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Domain From Url

Extract domain URL with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Domain From Url Address

Extract domain URL address with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Domain From Link

Extract domain link with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Domain From Web Address

Extract domain web address with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Host From A Url

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