公式库

Excel Formula To Extract Text Before First Dash In Product Feed Text

Extract Text Before First dash in product feed text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Extract Text Before First dash in product feed text.

统一公式

ExcelWPS
=TEXTBEFORE(A2, "-")
查看平台差异

Google Sheets

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

使用说明

需要定制版本？

相关公式

Excel Formula To Extract Text Before First Dash In Transaction Text

Extract Text Before First dash in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Text Before First Underscore In Transaction Text

Extract Text Before First underscore in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Text Before First Space In Transaction Text

Extract Text Before First space in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Text Before First Dash In Imported Csv Text

Extract Text Before First dash in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Text Before First Underscore In Imported Csv Text

Extract Text Before First underscore in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Extract Text Before First Space In Imported Csv Text

Extract Text Before First space in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.