I have some fixed width text files, they are space delimited format text and have .PRN file extension, I need to convert these .PRN to Excel .xls files quickly and easy. I can save it as an excel sheet using MS Excel but everything is in one cell. How do I split it into cells so I can work with the numbers and still have the text, thanks!
A: You can open .PRN files as Text Files (*.prn; *.txt; *.csv), and in Text import wizard select "Fixed width", final follow wizard steps to import .prn to excel file.
Importing .prn into Excel can be a labor-intensive process if you're going through the same steps over and over again. Fortunately, there is a software can automatically and quickly batch convert prn to excel files, you can save yourself quite some work and at the same time improve consistency.
Fast PRN to Excel Converter can convert .PRN (Space Delimited Formatted Text) files to MS Excel XLS files or .CSV (Comma Delimited) files or .TXT (Tab Delimited Text) Files, and can watch source file folder and convert new uploading PRN to excel documents automatically. you can convert a lot of files once time, saving your time!
It is a standalone tool, and doesn’t require MS Excel to be installed.
Manual Conversion Interface of fast prn to excel converter