[thelist] Splitting the contents of an Excel cell

[fstorr]

Hi all

Don't know if this is possible.

I've been given a large (the equivalent of 50 pages of A4) Excel
document that I need to reformat for a database.

The data is currently like this (pseudo stuff)

Cell
Artist Name/Record Title
/Cell


And I'd like it to be

Cell
Artist Name
/Cell
Cell
Record Title
/Cell

Is there any way possible to separate the single line of text into 2
different cells and remove the slash?

Cheers

Francis