I have this excel column where data is in the form “846325/00259269”.
There are two process which I need to do:
I want to remove the “/” in between and replace it with a “_” as such: “846325_00259269”. So creating a new column with the modification.
Extract only the first values before the “/” as such: “846325”.
Again a new column should be created.
The Excel does not have the column arlready. The bot should create the columns and paste the modifications in it.
Can anyone help please?
Excel_Preprocessed.xlsx (17.9 KB)