公式库

Excel Formula To Grab Text After An Underscore In A Text String

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

快速答案

Grab text after an underscore a text string.

统一公式

ExcelWPS
=TEXTAFTER(A2, "_")
查看平台差异

Google Sheets

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

使用说明

需要定制版本？

相关公式

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

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

Excel Formula To Extract Text After A Dash In Raw Text

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

Excel Formula To Extract Text After A Comma In A Text String

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

Excel Formula To Extract Text After A Comma In Raw Text

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

Excel Formula To Extract Text After A Slash In A Text String

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

Excel Formula To Extract Text After A Slash In Raw Text

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