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

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

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

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, "-")

View platform differences

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

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

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

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

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

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

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