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 Last Segment By Pipe In Analytics Event Text

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

Extract Last Segment By pipe in analytics event text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Last Segment By pipe in analytics event text.

ExcelWPS

=TEXTAFTER(A2, "|", -1)

View platform differences

=TRIM(RIGHT(SUBSTITUTE(A2, "\|", REPT(" ", 200)), 200))

Extract Last Segment By comma in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Last Segment By dash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Last Segment By slash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Last Segment By underscore in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Last Segment By pipe in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Last Segment By space in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.