公式库

Excel Formula To Find Website Domain From a column

Find website domain a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Find website domain a column.

统一公式

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

Google Sheets

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

使用说明

需要定制版本?

相关公式