I import a daily report and I need to remove part of a string. As an example the data I receive "42642_19_8" but I need to remove "_19" so I end up with "42642_8". If possible I would like to overwrite what is in the column but this could be an additional column if necessary. At present I am writing a formula to achieve this. Cheers
Bookmarks