公式库

Excel Formula To Extract Query Param Ref From Url In Product Feed Text

Extract query parameter ref from URLs in product feed text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Extract query param ref from url in product feed text.

统一公式

ExcelWPS

=LET(q,IFERROR(TEXTAFTER(A2,"?"),""),pairs,TEXTSPLIT(q,"&"),m,FILTER(pairs,LEFT(pairs,LEN("ref="))="ref="),IFERROR(TEXTAFTER(INDEX(m,1),"="),""))

查看平台差异

Google Sheets

=IFERROR(REGEXEXTRACT(A2, "(?:[?&])ref=([^&#]+)"), "")

使用说明

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

需要定制版本？

相关公式

Excel Formula To Extract Query Param Utm_Source From Url In Transaction Text

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

Excel Formula To Extract Query Param Utm_Medium From Url In Transaction Text

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

Excel Formula To Extract Query Param Utm_Campaign From Url In Transaction Text

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

Excel Formula To Extract Query Param Utm_Term From Url In Transaction Text

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

Excel Formula To Extract Query Param Utm_Content From Url In Transaction Text

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

Excel Formula To Extract Query Param Ref From Url In Transaction Text

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