公式库

Excel Formula To Remove Suffix -Backup From Text In Analytics Event Text

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

快速答案

Remove suffix -BACKUP from text in analytics event text.

统一公式

ExcelGoogle SheetsWPS
=IF(RIGHT(A2, LEN("-BACKUP"))="-BACKUP", LEFT(A2, LEN(A2)-LEN("-BACKUP")), 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.