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.
