At 20:51 18/11/2007 -0500, Stephen Hamburger wrote:
If I have a file with a bunch of data laid out in lines like this:
20/02/04 08:41:54 107.690000 107.720000
When I open the file in the .calc program each line of data is
placed within a single cell (Cell "A")...is it possible to import
the data so each field is placed in a separate cell? So for example
the date is in the first cell, the time in the second cell, etc...
If you are using Windows (and possibly otherwise), here is what to do:
o Rename your text file so that its extension is .csv.
o Open the file from within OpenOffice or right-click the file and
choose Open With... and browse to OpenOffice.
o In the Text Import dialogue, put a tick by Space under "Separated
by" (and make any other desired adjustments).
o Choose OK.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
