Formula Library

Excel Formula To Grab Text After An Underscore In a cell

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

Quick answer

Grab text after an underscore a cell.

Unified formula

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

Google Sheets

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

How it works

Need a custom version?

Related formulas