[thelist] Splitting the contents of an Excel cell
fstorr
fffrancis at fstorr.demon.co.uk
Mon Aug 19 13:05:00 CDT 2002
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
More information about the thelist
mailing list