• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

txt file seperation

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?
1 Solution
Rory ArchibaldCommented:
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.
gannon24Author Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now