importing .prn files

[jroth]

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.

 

[Gord Dibben]

You probably used Data>Text to Columns>Delimited by "space" for some other
operation.

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

Run through Data>Text to Columns with some dummy text and change the delimiter
to nothing.


Gord Dibben MS Excel MVP

 

[jroth]

Gord-
thank you very much for the assistance.

joel