+ Reply to Thread
Results 1 to 2 of 2

Analyze & Filter data in a notepad file

  1. #1
    Rudodoo
    Guest

    Analyze & Filter data in a notepad file

    I have a lot of data in a notepad file. This data contains information I
    need to create a database. I want to put it in a Excel worksheet b/f I
    transfer it into Access. The notepad file contains various information
    packed up together, but seperated by comma's. All the information is in the
    same order on the notepad file (For ex. MLS #, Address, City, St., Zip Code,
    etc...). I was wondering if Excel 2003 canl search through the file, and
    filter the different types of data I need from the ones I don't. Then insert
    the data in a spreadsheet which will organize it according to its particular
    category

  2. #2
    Pete
    Guest

    Re: Analyze & Filter data in a notepad file

    Presumably you have a filename like filename.txt. Use File | Open in
    Excel, select "All files" for Type of File and then browse folders to
    select your file. Excel will automatically take you through the Data
    Import Wizard - here you specify what row to start with, what the
    delimiter is and in the final panel you can specify the data type for
    each field. Here you can also specify to "SKIP" that column, thereby
    leaving out the data you do not need.

    Pete


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1