I need to combine all the data in the workspace above so i created a excel as follows
filename = 'testdata.xlsx';
- I need to remove all "/" from the data
- I need to cut the data which starts with "M" and Ends with symbol "|" and save it as new data
Please help me regarding the same.
Thank you in advance.