ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Quotation Marks (https://www.excelbanter.com/excel-discussion-misc-queries/140230-quotation-marks.html)

9pluck9

Quotation Marks
 
I have an excel doc, I save it as a .csv and then open the excel doc using
word pad
some of the text should include quotation marks but they are not there.
It does work using access though.
Any suggestions as how to get the quotation marks to show up.

Thank you
--
9pluck9

challa prabhu

Quotation Marks
 
Hi,

Microsoft 2003.

1. On the File menu, click Save As.
2. In the Save as type list, select CSV(Comma delimited) (*.csv)
3. Click Save.
4. Right-click the file icon in the open it with Notepad program

Challa Prabhu

"9pluck9" wrote:

I have an excel doc, I save it as a .csv and then open the excel doc using
word pad
some of the text should include quotation marks but they are not there.
It does work using access though.
Any suggestions as how to get the quotation marks to show up.

Thank you
--
9pluck9


RandyW

Quotation Marks
 
Hi,

Unfortunately, that doesn't work. I'm having the same problem. When saving
as a CSV, no quotation marks are generated. When I place quotation marks
around each cell entry and save it as CSV, the file generates 3 sets of
quotes around each data element. Any suggestions?

Thanks
Randy

"challa prabhu" wrote:

Hi,

Microsoft 2003.

1. On the File menu, click Save As.
2. In the Save as type list, select CSV(Comma delimited) (*.csv)
3. Click Save.
4. Right-click the file icon in the open it with Notepad program

Challa Prabhu

"9pluck9" wrote:

I have an excel doc, I save it as a .csv and then open the excel doc using
word pad
some of the text should include quotation marks but they are not there.
It does work using access though.
Any suggestions as how to get the quotation marks to show up.

Thank you
--
9pluck9



All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com