Hi All
I need a formula that will remove the Brackets and Text from within Cells in a row. My issue is that there are certain instances where the are multiple brackets to be removed. The source date is not mine so i cannot edit it. Alternatively a VBA to do the same thing may be better. There are only a maximum of 25 rows. Here are the examples of how the text appears in the sheet attached. There are also instances where there is a "*" out of the brackets. I'm not too fussed about removing that but if something could be incorporated into the formula to remove that would be great.
Bookmarks