Convert prn files to excel?

  • Thread starter Thread starter Guest
  • Start date Start date
ROYSTA said:
How to convert prn files to excel files?
Click to expand...

If they're the .prn files I've worked with in the past, import them using
the text import wizard and then Save As... (or am I missing the point?)
 
..prn files could be from any one of a number of applications.

What application is the file coming from?
Perhaps the application might have other file formats that would convert
easier, such as .csv, or even .txt.
 
ROYSTA,

Change the filename extension to .txt (if necessary). Now do File - Open.
THat will invoke the import wizard. Use "fixed." You can tell it the
extents of the fields. Prn files are usually full of spaces (to get stuff
where it needs to be when printed). You would set up fields of those
spaces, and select "skip." With patience, I think you can probably get it
done.

If you're not sure exactly where the data is, character-wise, open it with
NotePad, or a text editor. There's the Edit program (Start - Run - Edit).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

importing .prn files 2
save as a .prn file 1
Line lenght limit while saving as a PRN file 4
Problem with Saving Excel File as PRN 4
create fixed length cells & rows in excel as space delimited .prn 1
Converting excel to text file - Issue with wrapping text 7
Excel: wheres menu item to change file format conversion options? 1
Exporting to "prn" adding extra spaces with Excel 2003 2

Back
Top