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 Grab Text Before An Underscore In A Text String

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

Grab text before an underscore a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Grab text before an underscore 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.