I have a lot of data in this notepad file. It 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 can search through the file, and
filter the different types of data I need from the ones I don't. Then insert
that data in a spreadsheet which will organize it according to its particular
category