View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default txt files into one spreadsheet

See
http://www.rondebruin.nl/csv.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Barb" wrote in message ...
I'm probably just having a 'blonde moment', but can't for the life of me
think of how to import 170 *.txt files into 1 excel spreadsheet.

I'm running Office '07. The *.txt files are created from another program
that saves each page as 1 *.txt file. I need to combine all of these into 1
spreadsheet, so I can add up the $ amounts.

I've gone into the Excel and thought that I should be able to just 'insert -
file', but don't see that as an option. What am I missing?
Thanks,
Barb