Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Charlie Gotwald
 
Posts: n/a
Default No blank lines in text files

When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)
  #2   Report Post  
Charlie Gotwald
 
Posts: n/a
Default

Oops, managed to send the same question twice! How can one delete a subject?

"Charlie Gotwald" wrote:

When opening a comma delimitted file, I don't get blank lines anymore. In
Excel 2000, if a line in the text file was empty I would get an empty row in
the new spreadsheet. Now all non-blank rows are jambed together in one
column! How do I get Excell2003 to opoen Comma Delimitted files properly
(including empty lines?)

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
extract text from html files Glowinafuse Excel Discussion (Misc queries) 3 May 31st 05 06:23 AM
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM
Importing txt csv files into Excel greater than 65k lines strippier Excel Discussion (Misc queries) 1 April 20th 05 06:34 PM
?? Extra blank lines in 'address' cell after exporting to Excel Hadyn Pkok Excel Discussion (Misc queries) 4 April 15th 05 11:34 PM
importing multiple text files??? tashayu Excel Discussion (Misc queries) 0 December 19th 04 02:43 PM


All times are GMT +1. The time now is 01:36 PM.

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

About Us

"It's about Microsoft Excel"