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 Prefix Ref- From Text In Imported Csv Text

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

Remove prefix REF- from text in imported csv text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Remove prefix REF- from text in imported csv text.

ExcelGoogle SheetsWPS

=IF(LEFT(A2, LEN("REF-"))="REF-", MID(A2, LEN("REF-")+1, 999), A2)

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

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

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

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

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

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