公式库

Excel Formula To Capture Website Host From Link

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

快速答案

Capture website host link.

统一公式

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

Google Sheets

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

使用说明

需要定制版本?

相关公式