[thelist] Splitting the contents of an Excel cell

[Kid Stevens]

I could reformat that on my Mac in about 10 minutes with Filemaker
Pro then output that into cells.

  To do that you need to open the file in Excel.  Do a find and
replace on "/" in Excel and replace with the "Tab" mark and save as
tab delimited.  Then reopen and set import to tab.  Read the Excel in
as tab delimited to verify that the text breaks as you want it to.

Still alot of hand work except for my original way.

At 6:55 PM +0100 8/19/02, fstorr wrote:
>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
>
>
>--
>For unsubscribe and other options, including
>the Tip Harvester and archive of thelist go to:
>http://lists.evolt.org Workers of the Web, evolt !


--
Sincerely,
Kid Stevens

"Warning,
Do not meddle in the affairs of Dragons.
They will make you crunchy and eat you with ketchup."
-Unknown Author