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

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?