Excel Question

  dazwm 10:27 04 Dec 06
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 06

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

  dazwm 10:52 04 Dec 06

Thanks VoG™ thats done it.

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009