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 Remove Query String From Url In Analytics Event Text

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

Remove query strings from URLs in analytics event text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove query string from url in analytics event text.

ExcelWPS

=IFERROR(TEXTBEFORE(A2, "?"), A2)

View platform differences

=IFERROR(INDEX(SPLIT(A2, "?"), 1), A2)

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

Remove query strings from URLs in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

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

Remove query strings from URLs in webhook payload text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove query strings from URLs in support ticket text with a ready-to-use formula for Excel, Google Sheets, and WPS.

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