How do I use the Excel Formula To Grab Text After A Dash In a cell formula?

Paste the formula into the first output cell, then fill down to apply it to your range.

Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

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

Grab text after a dash a cell.

ExcelWPS

=TEXTAFTER(A2, "-")

View platform differences

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

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

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

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

Extract text after a comma raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.

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

Extract text after a slash raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.