Saving to a csv without the quotes

L

laredotornado

Hi,

I'm using MS Excel 2003. I have a spreadsheet with a single column of
character data (there are no quotes in any of the cells). How do I
save out to CSV so that leading and ending quotes are not inserted
before and after each cell of data?

Thanks, - Dave
 
D

Dave Peterson

Since it's just a single column, I'd just copy that column and paste into
NotePad. Then save that NotePad file as *.csv.
 

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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
JSON to CSV Conversion Gone Wrong: Got a Single Line of 991 Entrieswith Cells In Between. How Do I F 13
Losing leading 0 when saving as .csv 2
CSV and Custom Fields 6
Possible to save Excel as CSV with HTML codes? 2
Creating a csv 4
Differences Between Two Spreadsheets ? 1
References to cells in another workbook 3

Top