Single quotes work fine too, even without escaping the double quotes, at least in Excel 2016: 'text with spaces, and a comma','more text with spaces','spaces and 'quoted text' and more spaces','nospaces','NOSPACES1234' Excel will put that in 5 columns (if you choose the single quote as 'Text qualifier' in the 'Text to columns' wizard). Apr 30, 2012 - When working with CSV files you may need to add quotes to either side of a cell's. The PROPER way to do this is to use an escape character to inject the double quotes. Robert Mac on December 17, 2012 at 11:52 pm.

For those that have control over the source data, apparently Excel will auto-detect the format of a CSV field unless the CSV column is in this format: '='Data Here'' eg. 20, 5.5%, '0404 123 351', '3-6', '='123'' [number] [percent] [number] [date] [string]. Like many, I have been struggling with the same decisions that Microsoft makes and tried various suggested solutions. For Excel 2007 the following goes: • Putting all values in double quotes does NOT help • Putting an = before all values after putting them in double quutes DOES help, BUT makes the csv file useless for most other applications • Putting parentheses around the double quotes around all values is rubbish • Putting a space before all values before putting double quotes around them DOES prevent conversions to dates, but DOES NOT prevent trimming of leading or trailing zeroes. • Putting a single quote in front of a value only works when entering data within Excel.

However: Putting a tab before all values before putting double quotes around them DOES prevent conversions to dates AND DOES prevent trimming of leading or trailing zeroes and the sheet does not even show nasty warning markers in the upper left corner of each cell. E.g.: ',' Note that the tab character has to be within the double quotes. Edit: it turns out that the double quotes are not even necessary. Double clicking the csv file can open the file as a spreadsheet in Excel showing all values that are treated as just above, like text data.

Make sure to set Excel to use the '.' As the decimal point and not the ',' or every line of the csv file will end up as one text in the first cell of each row. Apparently Microsoft thinks that CSV means 'Not the decimal point' Separated Value.

Video maker software for mac free download. HyperEngine-AV is a free video editing software for Mac used to capture, edit, organize process, and export video, audio, and text to create DVD quality movies and slide shows. It comes with twelve studio-quality effects from Arboretum's Hyperprism suite of audio processors.

Or you could do this: strAnswer = strStart & Chr(39) & strFinish 'Chr(39) is a single quote strAnswer = strStart & Chr(34) & strFinish 'Chr(34) is a double quote And, if you define a constant for either of these, then you could have Public Const strSingleQuote as String = '' Public Const StrDoubleQuote as String = '' You could then substitute these constants into your formulae. HTH, Eric Tu ne cede malis sed contra audentior ito In you code, strStart and strFinish are useful and they are treated as starting and ending delimiter by VBA. However, in help file I cannot find them. Where are they defined? Are they something like macros defined in include files (.h) in C/C++?