Formula Library

Excel Formula To Return Text After A Dash In A Text String

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

Quick answer

Return text after a dash 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