Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

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

Paste the formula into the first output cell, then fill down to apply it to your range.

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

Remove suffix -V1 from text in crm export text.

ExcelGoogle SheetsWPS

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

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

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

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

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

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

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