txt file seperation

Posted on 2011-10-21
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

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now