2008/3/3, Shreeram Shetty <[EMAIL PROTECTED]>: > > Hi, > I am using Calc in Open Office 2.3. I want to import a text file of > a long list of numbers separated by new lines. ( one column) > > I want to import these numbers into Calc and store them in 4 columns > instead of just one. Is there any way I can do that? > > Thanks, > > > Shreeram Shetty
Yes, probably. How do you want to do it? Automatically or manually? What do you want it to look like? Like Example 1 or 2 below? Example 1 (the list below is telling us where each line of the original text file is located on the spreadsheet, first line mentioned first and so on): Before: A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 A15 A16 After: A1 B1 C1 D1 A2 B2 C2 D2 A3 B3 C3 D3 A4 B4 C4 D4 Example 2: Before: A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 A15 A16 After: A1 A2 A3 A4 B1 B2 B3 B4 C1 C2 C3 C4 D1 D2 D3 D4 If Example two is what you are looking for it's quite simple to just move the cells afterwards manually. If Wxample 1, I would write a macro to move the cells. J.R.
