LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Import *.asc file into excel fixed width

I am opening a .asc file into excel. When i do so i get the import text wizard and choose fixed width. The file contains several hundred lines of information with about 300 characters on each line. The default column dividers are not correct for the way i need the data broken up. For instance; The 25 characters in position 41-65 is the name of a person but the column divider is set at position 53 splitting up the name. It takes me a considerable amount of time to change the dividers for this whole file. What I would like to do is automate the task. What tool can I use to import the file into excel and automatically set 110 column dividers at very specific points.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fixed Width Text Import Settings Bryan Excel Discussion (Misc queries) 4 July 8th 08 12:15 AM
Converting an Excel file to Fixed Width [email protected] Excel Discussion (Misc queries) 3 March 22nd 07 04:42 PM
Repeatable Fixed Width Import donnie darko Excel Discussion (Misc queries) 9 December 6th 06 06:47 PM
HOW DO YOU SET THE DEFAULT FIXED COLOMN WIDTH ON THE EXCEL IMPORT Robert Belote Excel Discussion (Misc queries) 0 May 5th 06 08:33 PM
Automate the Text Import Wizard (Fixed Width) Yagnesh Excel Worksheet Functions 5 August 25th 05 08:08 PM


All times are GMT +1. The time now is 01:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"