Text to column.... not :-(

[suziequeue]

I have data like this:

Row 1: Ibuprofen Paracetamol Zopiclone Gabapentin
Row 2: E45 Malathion Isosorbide mononitrate Aspirin
Row 3: Gaviscon Bisulphate Paracetamol Aciclovir

etc etc

I would like to "de-concatenate" it.

I can't do text to column as the words are different lengths in different rows.

Other than going through all the words and putting a ";" between them all and then using the delimiting function, can anybody suggest a quicker way?

Susanna

 

[Richard Schollar]

Hi Suzanna

Why can't you do a TextToColumns with space as a delimiter?

 

[suziequeue]

Jeez

I've been slaving at this all morning. Now - 5 seconds on here and it's fixed!!

THANKYOU