I have some text within cells I wish to split up. They are in this format:- Robbie Williams-Angels. I want to split them so that for example Robbie Williams is in cell A1 and Angels in B1. There are loads others like this but obviously different amounts of characters. Is there a formula that will do all of these.