Excel Question

  dazwm 10:27 04 Dec 2006
Locked

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.

  VoG II 10:39 04 Dec 2006

Click in A1, Data > Text to Columns, follow the prompts and specify - as the delimiter.

  dazwm 10:52 04 Dec 2006

Thanks VoG™ thats done it.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?