| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I put quotes around a field in Excel 2007
I am trying to put double quotes around some of the fields in Excel and then
save as a csv file. I have tried char(34), but this results in 3 sets of double quotes. Does anyone know how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I put quotes around a field in Excel 2007
Have you tried saving the file as csv and then opening the csv file
with notepad to check what you really have? If you use Excel to open the csv file then some characters may be lost and/or changed, as Excel has its own rules for how to deal with different fields. Hope this helps. Pete On Feb 19, 4:23*pm, HH Stacy <HH wrote: I am trying to put double quotes around some of the fields in Excel and then save as a csv file. *I have tried char(34), but this results in 3 sets of double quotes. Does anyone know how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MSN Stock Quotes Addin for Excel 2007 | Excel Discussion (Misc queries) | |||
| How to edit MSN Stock Quotes in Excel 2007 | Excel Discussion (Misc queries) | |||
| Get stock quotes in Excel 2007 | Excel Discussion (Misc queries) | |||
| Stock Quotes for Excel 2007 | Excel Discussion (Misc queries) | |||
| export .CSV with field containing double quotes? | Excel Discussion (Misc queries) | |||
Linear Mode
