Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default txt files into one spreadsheet

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet of files... Help bwhunt1923 Excel Worksheet Functions 2 August 21st 07 08:35 PM
hiding files in the same spreadsheet Mike Excel Discussion (Misc queries) 2 January 5th 07 01:45 AM
MP3 files and Excel spreadsheet [email protected] Excel Discussion (Misc queries) 3 July 17th 06 10:34 PM
merge csv files into spreadsheet [email protected] Excel Discussion (Misc queries) 2 March 16th 06 02:05 PM
creating multiple files from a spreadsheet Carol Summa Excel Discussion (Misc queries) 1 March 17th 05 12:07 PM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"