View Single Post
  #1   Report Post  
StarBoy2000
 
Posts: n/a
Default 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.