Formula Library

Excel Formula To Return Text After An Underscore In a column

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

Quick answer

Return text after an underscore a column.

Unified formula

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

Google Sheets

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

How it works

Need a custom version?

Related formulas