Formula Library

Excel Formula To Pull Text After An Underscore In a cell

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

Quick answer

Pull 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