Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text-files
When I open a text-file, the Text Import Wizard is displayed which has
three steps: In Step 1, I indicate whether the file is delimited or fixed width. In Step 2, I indicate where I want the column breaks to occur. In Step 3, I indicate the format of the data in each column. I very frequently open text-files whose rows have a length of 1,274 characters and, when the column breaks are created, there are 108 columns. Rather than going through all that work everytime, how can I set up a "template" (?) that will automatically import the file, break the data into the 108 columns and format the cells correctly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Need Help Importing Text File Using Two or More Spaces as the Delimiter | Excel Discussion (Misc queries) | |||
Help extract numerous text files and how to use avg formula | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Importing Text Files | Excel Discussion (Misc queries) |