公式库

Excel Formula To Derive Root Domain From Url Address

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

快速答案

Derive root domain URL address.

统一公式

ExcelWPS

=LET(url, A2, TEXTBEFORE(TEXTAFTER(url, "//"), "/"))

查看平台差异

Google Sheets

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

使用说明

将示例区域（如 A2:A）替换为你的实际区域。
保持与示例一致的列顺序。
向下填充以应用到所有行。

需要定制版本？

相关公式

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.