importing .prn files
 

Up until a few weeks ago, when I dragged a .prn file into excel, each line
would appear in a single cell.

Recently, excel now parses the file into columns, based on spaces in the
..prn file. I don't want this. I prefer each line in a single cell.

any suggestions?

thank you.

importing .prn files
 

You probably used DataText to ColumnsDelimited by "space" for some other
operation.

Excel remembers this.........thank you much<g

Run through DataText to Columns with some dummy text and change the delimiter
to nothing.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 13:55:01 -0700, jroth
wrote:

Up until a few weeks ago, when I dragged a .prn file into excel, each line
would appear in a single cell.

Recently, excel now parses the file into columns, based on spaces in the
.prn file. I don't want this. I prefer each line in a single cell.

any suggestions?

thank you.

importing .prn files
 

Gord-
thank you very much for the assistance.

joel

"Gord Dibben" wrote:

You probably used DataText to ColumnsDelimited by "space" for some other
operation.

Excel remembers this.........thank you much<g

Run through DataText to Columns with some dummy text and change the delimiter
to nothing.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 13:55:01 -0700, jroth
wrote:

Up until a few weeks ago, when I dragged a .prn file into excel, each line
would appear in a single cell.

Recently, excel now parses the file into columns, based on spaces in the
.prn file. I don't want this. I prefer each line in a single cell.

any suggestions?

thank you.