Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Excel Formula To Extract Query Param Ref From Url In Crm Export Text

Paste the formula into the first output cell, then fill down to apply it to your range.

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

Extract query param ref from url in crm export text.

ExcelWPS

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

View platform differences

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

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

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

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

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

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

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