txt file seperation

Posted on 2011-10-21
Medium Priority
Last Modified: 2012-08-14
In the older versions of Excel and Access I could import a text file and manually drag divider lines to seperate character spaced data.  Now I can't seem to do it in office 2007.  Is there a way to still take a text file and manually tell where each column starts and stops in excel and access?
Question by:gannon24
LVL 85

Accepted Solution

Rory Archibald earned 2000 total points
ID: 37005928
You can still do that in Excel - when you open a text file, the import text wizard pops up - just specify fixed width and then choose the columns in the next step.

Author Closing Comment

ID: 37006112
Thanks for the quick response.  I haven't done that in about 10 years and forgot which setting to select to accomplish that.  I hate cobwebs, haha.  Thanks again.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question