[FIXED] How to Escape Comma within Formula in CSV file

Issue

I'm trying to create a CSV file (Excel or LibreOffice) which contains a formula that uses multiple arguments separated by a comma. The comma is interpreted as a field separator. Is it possible to escape the comma somehow so formula requiring commas can be used?

This works as expected:

=Sum(A1:A10)

This doesn't read correctly due to use of comma in formula:

=Confidence.Norm(.01, Stdev.p(A1:A10), 10)

Imagined solutions that don't work:

=Confidence.Norm(.01 \, Stdev.p(A1:A10) \, 10)
=Confidence.Norm(.01 ',' Stdev.p(A1:A10) ',' 10)
=+"Confidence.Norm(.01 \, Stdev.p(A1:A10) \, 10)"

Solution

Try this:

"=Confidence.Norm(.01, Stdev.p(A1:A10), 10)"

Answered By - BenjiBoyWick

Answer Checked By - Mildred Charles (PHPFixing Admin)