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 Pull Text After An Underscore In Raw Text

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

Pull text after an underscore raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Pull text after an underscore raw text.

ExcelWPS

=TEXTAFTER(A2, "_")

View platform differences

=INDEX(SPLIT(A2, "_"), 2)

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

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

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

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

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

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