How to quote a quote with the CONCATENATE function in OOCalc
Solution 1:
This works for me:
=CONCATENATE("""",A1,"""")
Repeating the quotes escapes them (as it does in Visual Basic, I believe), so """" reads as: 'one quote to start a string, one escaped quote (""), then one quote to finish the string'.
Solution 2:
Use char(34) to get the quote character.
CONCATENATE(char(34); B2; char(34))