AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. Salinger.īeware that Calc's AutoCorrect function may modify double quotation marks. Salinger.' displays the string 'The Catcher in the Rye' is a famous book by J. For example, the formula =UNICHAR(34) & 'The Catcher in the Rye' & UNICHAR(34) & ' is a famous book by J. You can use the CHAR function or the UNICHAR function to insert a double quotation mark. Another simple example is the formula =UNICODE('''') which returns 34, the decimal value of the Unicode quotation mark character (U+0022) - here the first and fourth double quotation marks indicate the beginning and end of the string, while the second double quotation mark escapes the third. For example, the formula ='My name is ''John Doe''.' outputs the string My name is 'John Doe'. You can 'escape' the double quotation mark with an additional double quotation mark, and Calc treats the escaped double quotation mark as a literal value. To place a literal double quotation mark within a string inside a formula, two methods can be used: The more complex formula =CONCATENATE('Life is really simple, ' 'but we insist on making it complicated ' '(Confucius).') concatenates three individual strings in double quotation marks, outputting Life is really simple, but we insist on making it complicated (Confucius). For example, the formula ='Hello world!' displays the text string Hello world! in the cell, with no surrounding double quotation marks. To include a text string in a formula, place the text string between two double quotation marks (') and Calc takes the characters in the string without attempting to interpret them.

Last version of spell catcher x was