How to quote a quote with the CONCATENATE function in OOCalc

user_183579 0
Viewed 126263

In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A.

So in cell B1 I want to do:

=CONCATENATE("\"",A1,"\"")

OOCalc does not like this, or without the escaping backslash.

Does anyone know how to do this, or what an alternative method might be?

openoffice-calc concatenation
5 Answers

Use char(34) to get the quote character.

CONCATENATE(char(34); B2; char(34))
user_14776870
Related