Formula Library

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

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

Quick answer

Extract query param page from url in product feed text.

Unified formula

ExcelWPS
=LET(q,IFERROR(TEXTAFTER(A2,"?"),""),pairs,TEXTSPLIT(q,"&"),m,FILTER(pairs,LEFT(pairs,LEN("page="))="page="),IFERROR(TEXTAFTER(INDEX(m,1),"="),""))
View platform differences

Google Sheets

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

How it works

Need a custom version?

Related formulas