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 -- Guy using dutch OOo 2.3 m221 on a iMac Intel DualCore Tiger and brazilian OOo 2.3 RC 3 on a G4 PPC Powerbook Tiger -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches