Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I have a basic excel file with a few columns with data. Now I need to import this data to my financial system (iScala). It seems iScala can only import textfile where each value starts at a predefined position; hence it does not support "tab" or "space" delimited values. Does anyone know how to create a text file where all records are "surrounded" by space and each record starts (at the same) predefined position? Example: 3 columns (A, B, C): Name1 071001 452 Name123 071201 1200 Nam1 070905 51 Notice that "date" (column B) always start at position 9 and column C at position 18... How to make this from a excel-file? Kindly, Mikael Sweden |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to create an ".iif" file from Excel for QuickBooks Pro 2001. | Excel Worksheet Functions | |||
Import text doc to XL. Need items seperated by " " in new column | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) | |||
.csv drops "0" when saved, even if file was set as "text". | Excel Discussion (Misc queries) |