Saving file as test file

  • Thread starter Thread starter Barbara O'Brien
  • Start date Start date
B

Barbara O'Brien

When I save an EXCEL file as a text file or as a PRN file,
I get a quote " at the beginning and end of each row.
Does anyone know how to stop EXCEL from generating these
quotes? My rows contain numbers, aplha characters, and
spaces.
 
It assumes you want quotes there as separators for whatever program will
import them next. Go to www.downloads.com, pick up a copy of NoteTab (free),
and use search/replace to get rid of the quotes. You could also do this with
Word.
 
Barbara,

I can't explain the " in the prn file, unless it's in the cells. Give an
example, showing exactly what's in the cells, and what it writes to a prn
file. Open the prn file with Notepad to see precisely what's in it.
 
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

Line lenght limit while saving as a PRN file 4
save as a .prn file 1
create fixed length cells & rows in excel as space delimited .prn 1
Working Around 240 Character PRN Field Width Limit 1
Problem with Saving Excel File as PRN 4
Saving As. . PRN file problem broken up columns.. 1
Converting an Excel file to Fixed Width 3
Excel CSV Files; Creating Of 3

Back
Top