Hi,

Thanks for your prompt response, its quite working well on individual cells, while running on table its getting error "5991" after deleting a native text its creating a table enter for every cell. I had given example as Income but here condition is .([a-z]) i.e. english words or terms shouldnt get deleted before the backslash.
Example: long/short , assets/debt, equity/sales, these are all examples and shouldnt get affected after running a macro.
Likewise values before the backslash also shoulldnt have impact.
Example: 1203/34343 , 1234/marks, 2021/stats

Issues:

Not running on a table giving error as 5991.

English words and values remain constant before the backslash.

Native text (Otherthan English Words (A-Z) & Values (0-9) only should deleted before the backslash including "/" (Strarts from begining of the cell to "/" get deleted).

Table Enter was creating deleting a native text in a individual cells. Table Enter again involves manual work to remove extra table enter.

Please find a attachment.

Your Help is highly appreciated.

Attached Files

Sample.docx (63.1 KB, 12 views)