公式库

Excel Formula To Extract Text Before First Slash In Transaction Text

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

快速答案

Extract Text Before First slash in transaction text.

统一公式

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

Google Sheets

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

使用说明

需要定制版本？

相关公式

Excel Formula To Extract Text Before First Comma In Transaction Text

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

Excel Formula To Extract Text Before First Pipe In Transaction Text

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

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

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

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

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

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

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

Excel Formula To Extract Text Before First Comma In Crm Export Text

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