公式库

Excel Formula To Remove Prefix Img- From Text In Transaction Text

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

快速答案

Remove prefix IMG- from text in transaction text.

统一公式

ExcelGoogle SheetsWPS

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

使用说明

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

需要定制版本？

相关公式

Excel Formula To Remove Prefix Id- From Text In Transaction Text

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

Excel Formula To Remove Prefix Sku- From Text In Transaction Text

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

Excel Formula To Remove Prefix Ord- From Text In Transaction Text

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

Excel Formula To Remove Prefix Inv- From Text In Transaction Text

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

Excel Formula To Remove Prefix Cus- From Text In Transaction Text

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

Excel Formula To Remove Prefix Lead- From Text In Transaction Text

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