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 Before A Pipe In A Text String

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

Extract text before a pipe a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract text before a pipe a text string.

ExcelWPS

=TEXTBEFORE(A2, "|")

View platform differences

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

Extract text before a dash a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract text before a dash raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract text before a comma a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract text before a comma raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract text before a slash a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract text before a slash raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.