importing .prn files

  • Thread starter Thread starter jroth
  • Start date Start date
J

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.
 
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
 
Back
Top