公式库

Excel Formula To Remove Suffix -B From Text In Webhook Payload Text

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

快速答案

Remove suffix -B from text in webhook payload text.

统一公式

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