Analyze & Filter data in a notepad file

[Guest]

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

 

[Pete]

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