Comma Separated Value Files

[dr_damo]

Hope this makes sense.

I have a worksheet of 80-90 records, I need to import it via a web portal which accepts .csv files.

However, if I save this sheet in Excel as a .csv file, it appears not to be saving with double quotes and commas.

What am I doing wrong and what, if anything, can I do to create a properly marked up .csv file? Without using notepad?

Excel 2003 btw.

 

[dr_damo]

Brilliant. I'll give the =char etc a go.

 

[dr_damo]

i'll use the =char etc

thanks!

 

[Joe4]

You may find that saving as a Space Delimited file (*.prn) is the best way to save that file (as you are really building the entire CSV layout all in one cell in Excel). You can still save it with a ".CSV" extension.