Hi
My suggestion is to load the file to writer. use search and replace and
replace the spaces with a single comma thus making the file a csv file
which will automatically be loaded in separate columns. Save from writer
as csv.
Ross
Guy Voets wrote:
2007/11/19, Stephen Hamburger <[EMAIL PROTECTED]>:
Greetings,
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 seperate cell? So for example the date is in the first
cell, the time in the second cell, etc...
Thank you.
Hello,
I suppose this can be done with the functions like LEFT, PART, RIGHT.
See the inbuild Help, Text Functions.
HTH
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.16.4/1146 - Release Date: 22/11/2007 18:55
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
