How to remove or split data in excel sheet

hi,
i have data in excel sheet.in (Description )column value is
CHARGES (cont.) DESCRIPTION RCG - Reporting of Conveyances and Goods (Exports) USD 30,00 @ 15.195367

i want data like --Reporting of Conveyances and Goods (Exports) USD 30,00 @ 15.195367–

how to Remove —CHARGES (cont.) DESCRIPTION----where ever this type of data Cell in Excel sheet ?

can any one help me.

data.xlsx (8.8 KB)

Hi @Anand_Designer

Maybe you can use Excel’s function of replacement to replace all of the “CHARGES (cont.) DESCRIPTION” with empty, the steps like below.
1.Open Excel file by Excel Application Scope
2.Send hotkey Ctrl+f
3.Send hotkey Alt+p
4.Type “CHARGES (cont.) DESCRIPTION” into find string
5.Send hotkey Alt+a
6.Click popup window’s OK button
7.Save workbook

1 Like