Convert prn files to excel?

I

Ian Ripsher

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?)
 
G

Guest

..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.
 
E

Earl Kiosterud

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).
 

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
convert from prn files to excel 1
create fixed length cells & rows in excel as space delimited .prn 1
Problem with Saving Excel File as PRN 4
Converting excel to text file - Issue with wrapping text 7
PRN Files 6

Top