View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hmm
 
Posts: n/a
Default Is there a batch text-to-columns feature?

I would like to create Excel charts based on data stored in a large number of
text files. Each file consists of lines of x-y coordinates; on each line, a
semi-colon separates the x and y value.

To convert these to Excel (2000), I know I can open the each file and use
the text-to-columns converter. But for the number of files I have, this
would be quite cumbersome.

Is there a feature that allows me to select a batch of files and convert
them all to Excel?

Thanks.