Jim Metcalf
asked on
Fixed width settings in Excel
Is there a way to type in the fixed width settings for a file you are about to import.
i don't want to use the scroll bar tool they have defining fixed width and also need to avoid macro.
example lets say i have a file that is in fixed width text and has columns of 10,10,12,and 4
is there a place i can either put
10,10,10,12,4 and have it automatically import the file with those settings.
i don't want to use the scroll bar tool they have defining fixed width and also need to avoid macro.
example lets say i have a file that is in fixed width text and has columns of 10,10,12,and 4
is there a place i can either put
10,10,10,12,4 and have it automatically import the file with those settings.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
is there a way for me to enter the text...
12,13,12,13,1,1,15
to identify the columns width's
of column one width 12 column 2 width 3 etc..... instead of me dragging the lines in the formatting wizard for fixed width import.
i have an enormously long file of 3000 characters and the widths of the columns are defined in a file layout document... i would like to plug in the numbers from the file layout document instead of using the following tool that i am attaching a screenshot of