公式库

Excel Formula To Remove Suffix -Final From Text In Imported Csv Text

Remove suffix -FINAL from text in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

快速答案

Remove suffix -FINAL from text in imported csv text.

统一公式

ExcelGoogle SheetsWPS
=IF(RIGHT(A2, LEN("-FINAL"))="-FINAL", LEFT(A2, LEN(A2)-LEN("-FINAL")), A2)

使用说明

需要定制版本？

相关公式

Excel Formula To Remove Suffix -Us From Text In Transaction Text

Remove suffix -US from text in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Remove Suffix -Eu From Text In Transaction Text

Remove suffix -EU from text in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Remove Suffix -Apac From Text In Transaction Text

Remove suffix -APAC from text in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Remove Suffix -Dev From Text In Transaction Text

Remove suffix -DEV from text in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Remove Suffix -Test From Text In Transaction Text

Remove suffix -TEST from text in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Excel Formula To Remove Suffix -Beta From Text In Transaction Text

Remove suffix -BETA from text in transaction text with a ready-to-use formula for Excel, Google Sheets, and WPS.