Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeatable Fixed Width Import
I work with a system which gives me a fixed width dump of data for each
file I request. This must then be imported into Excel, and the columns have to be lined up with the import wizard every time (about 50 columns)! The columns will always be the same width. How can I save or automate the column widths to easily import the data after setting up the columns just once? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an Excel SpreadSheet be saved/ exported: ASCII fixed width | Excel Discussion (Misc queries) | |||
HOW DO YOU SET THE DEFAULT FIXED COLOMN WIDTH ON THE EXCEL IMPORT | Excel Discussion (Misc queries) | |||
Changing fixed width (column break) defaults when importing text | Excel Discussion (Misc queries) | |||
Automate the Text Import Wizard (Fixed Width) | Excel Worksheet Functions | |||
Export to fixed width text file | Excel Discussion (Misc queries) |