Import a whole text file into a single cell

[mv5869]

How can I import a whole text field into a single cell in Excel, without the line breaks making Excel start a new row? I'd like the whole text document in a single cell.

I know I could copy and paste but I want to automate it.

Eventually, I would like to write a script to go through a whole directory and import each text file into a different cell of my spreadsheet. But small steps...

 

[Richard Schollar]

That must be an issue with either the content of the text file itself, or of the formatting you have applied in your excel sheet, as the code I posted doesn't change the contents of the text file in anyway: ii is brought in as is.