公式库

Excel Formula To Extract Subdomain Level 1 From Url In Transaction Text

Extract subdomain segments from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Extract subdomain level 1 from url in transaction text.

统一公式

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

Google Sheets

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

使用说明

需要定制版本？

相关公式

Excel Formula To Extract Subdomain Level 2 From Url In Transaction Text

Extract subdomain segments from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Subdomain Level 3 From Url In Transaction Text

Extract subdomain segments from URLs in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Subdomain Level 1 From Url In Imported Csv Text

Extract subdomain segments from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Subdomain Level 2 From Url In Imported Csv Text

Extract subdomain segments from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Subdomain Level 3 From Url In Imported Csv Text

Extract subdomain segments from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Subdomain Level 1 From Url In Crm Export Text

Extract subdomain segments from URLs in crm export text with a ready-to-use formula for Excel, Google Sheets, and WPS.