Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |