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.

Import *.asc file into excel fixed width
 

Hartsell,
Look up OpenText in the help and/or record a macro of your manual actions.

nickHK

"Hartsell" wrote in message
...
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.