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.
jamesmetcalf74Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
some automation need to be done, but before that how would u import the file to Excel? is it via existing Excel wizard or via Macro etc?
tomfarrarCommented:
Are you saying the field is already parsed into columns, or the data resides in one column of text?  If the data is in one column, you could import the column as is, and then use the left, mid and right function to parse the data into the five (or four) columns you used in your example.  

If the data is already in five (or four) columns, is the problem there are spaces in the data you want to get rid of?  If so you could use the trim function =trim() function to get rid of the spaces.  

Can you post an example of what you are talking about?
jamesmetcalf74Author Commented:
Lets say i have a fixed width file and am opening it with excel.
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
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

jamesmetcalf74Author Commented:
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
ok, now understand the issue you're facing.... In fact, I'm facing same issue as you mentioned above in which there seems no way for Excel to remember the fixed length settings of the file we gonna import. I could be lucky than you as I don't have a file with 3000 chars in a row.

and probably the fact is that we need to do it via macro instead. hence, you may try to record your importing steps using macro recording and see if this is helpful.

A references of macro recording output for text importing can be found at:

Excel 2007 save import steps on csv file?
http://superuser.com/questions/299605/excel-2007-save-import-steps-on-csv-file
tomfarrarCommented:
Yea, 3000 character to parse could be a problem.  How many approximate fields does it parse into?  Is this a one-time deal or something you need to do over and over?  - Tom

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.