Formula Library

Excel Formula To Get Text After An Underscore In A Text String

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

Quick answer

Get text after an underscore a text string.

Unified formula

ExcelWPS
=TEXTAFTER(A2, "_")
View platform differences

Google Sheets

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

How it works

Need a custom version?

Related formulas