View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

What goes in columns 1-3 and 8-15 of the new file?


In article ,
"StarBoy2000" wrote:

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.