Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
Search/Extract Data w/in Text File | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) |