公式库

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

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

快速答案

Remove suffix -COPY from text in transaction text.

统一公式

ExcelGoogle SheetsWPS

=IF(RIGHT(A2, LEN("-COPY"))="-COPY", LEFT(A2, LEN(A2)-LEN("-COPY")), A2)

使用说明

将示例区域（如 A2:A）替换为你的实际区域。
保持与示例一致的列顺序。
向下填充以应用到所有行。

需要定制版本？

相关公式

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.