Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
export to CSV file
I am exporting an Excel worksheet to a CSV file. I need each value in the
CSV file to be surrounded by double quotes. How do i do that? Thanks in advance! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
export to CSV file
CSV is Comma Separated... not quote comma separated.
You will have to either add quotes around each value or use a macro. See http://support.microsoft.com/kb/291296 for a macro solution. "_Ann_" wrote: I am exporting an Excel worksheet to a CSV file. I need each value in the CSV file to be surrounded by double quotes. How do i do that? Thanks in advance! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
export to CSV file
yeah i get the comma-separated point. But i find it odd that Excel will add
quotes if there is a comma in one of the cells. Was hoping for a bit more flexibility in formatting the comma-separate values. The app that will use the CSV files requores quoted values. Thanks for the link. I'll give it a try. "Sheeloo" wrote: CSV is Comma Separated... not quote comma separated. You will have to either add quotes around each value or use a macro. See http://support.microsoft.com/kb/291296 for a macro solution. "_Ann_" wrote: I am exporting an Excel worksheet to a CSV file. I need each value in the CSV file to be surrounded by double quotes. How do i do that? Thanks in advance! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
export to CSV file
It has to add quotes if the cell value contains a comma since the values are
separated by commas in CSV... otherwise the values with commas will be split over two or more fields... While answering a post we have no idea about the level of expertise of the person asking the questions so sometime we come across as condescending... "_Ann_" wrote: yeah i get the comma-separated point. But i find it odd that Excel will add quotes if there is a comma in one of the cells. Was hoping for a bit more flexibility in formatting the comma-separate values. The app that will use the CSV files requores quoted values. Thanks for the link. I'll give it a try. "Sheeloo" wrote: CSV is Comma Separated... not quote comma separated. You will have to either add quotes around each value or use a macro. See http://support.microsoft.com/kb/291296 for a macro solution. "_Ann_" wrote: I am exporting an Excel worksheet to a CSV file. I need each value in the CSV file to be surrounded by double quotes. How do i do that? Thanks in advance! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
export to CSV file
no offense taken :-) Thanks for your help.
"Sheeloo" wrote: It has to add quotes if the cell value contains a comma since the values are separated by commas in CSV... otherwise the values with commas will be split over two or more fields... While answering a post we have no idea about the level of expertise of the person asking the questions so sometime we come across as condescending... "_Ann_" wrote: yeah i get the comma-separated point. But i find it odd that Excel will add quotes if there is a comma in one of the cells. Was hoping for a bit more flexibility in formatting the comma-separate values. The app that will use the CSV files requores quoted values. Thanks for the link. I'll give it a try. "Sheeloo" wrote: CSV is Comma Separated... not quote comma separated. You will have to either add quotes around each value or use a macro. See http://support.microsoft.com/kb/291296 for a macro solution. "_Ann_" wrote: I am exporting an Excel worksheet to a CSV file. I need each value in the CSV file to be surrounded by double quotes. How do i do that? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I export an .xls file to Qif file format | Excel Discussion (Misc queries) | |||
export re-order input fields to export file [csv] | Excel Worksheet Functions | |||
need to export row as csv file with column e plus .bom as file name | Excel Discussion (Misc queries) | |||
I need to export.xls file to .csv file for fedex address book | Setting up and Configuration of Excel | |||
Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) |