Hi,
I have a lot of titles like "A Company - Strategy A", "A Company - Strategy B" and what I am hoping to do is strip out the part after the hyphen to the cell directly above. This is the case across about 200 columns, I'd imagine this is pretty easy?
The attached spreadsheet makes it very clear.
Thanks,
Tim
Bookmarks