公式库

Excel Formula To Remove Suffix -Tmp From Text In Crm Export Text

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

快速答案

Remove suffix -TMP from text in crm export text.

统一公式

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