| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Import Pipe Delimited File, Parse out certian Fields, create new f
In Excel 2000, how do I take a pipe delimited file, strip out column(field)
6, 10, 11, 21. Then take that data, create a new pipe delimited file, and put the stripped 4 fields in columns 4,5,6,7 of a 15 column(field) new pipe delimited file? I want to do this automatically on a file that contains 1000+ records. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| import external data from changing file name | Excel Worksheet Functions | |||
| save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
| I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Import file names into cells | Excel Worksheet Functions | |||
Threaded Mode
