R
ROYSTA
How to convert prn files to excel files?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
I
Ian Ripsher
ROYSTA said:How to convert prn files to excel files?
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
George King
..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.
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).
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).