On 19/11/2007, Stephen Hamburger <[EMAIL PROTECTED]> wrote: > > > 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. > > _________________________________________________________________ > You keep typing, we keep giving. Download Messenger and join the i'm > Initiative now. > http://im.live.com/messenger/im/home/?source=TAGLM
Rename the file so it has a ".csv" extension, run calc and do File>Open to open the file. In the "Text Import" pane that appears, select "Separated by" and then select "Space" as the *only* separator. You'll get one field per cell with each line of the file going into a new row. Now format the columns as appropriate although none should be necessary depending on your settings for date and time. -- Harold Fuchs London, England Please reply *only* to [email protected]
