How to quote a quote with the CONCATENATE function in OOCalc

Identical to the above but without the function:

="""" & A1 & """"

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'.

Use char(34) to get the quote character.

CONCATENATE(char(34); B2; char(34))