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 Text After First Pipe In Transaction Text

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

Extract Text After First pipe in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Text After First pipe in transaction text.

ExcelWPS

=TEXTAFTER(A2, "|")

View platform differences

=INDEX(SPLIT(A2, "\|"), 2)

Extract Text After First comma in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Text After First slash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Text After First comma in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Text After First slash in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Text After First pipe in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract Text After First comma in crm export text with a ready-to-use formula for Excel, Google Sheets, and WPS.