Did you actually try it? For me:

A1: hello
A2: =""""&a1&"""" === "hello"

The OP wanted double quotes around the contents, not single quotes.

In article ,
"Dave Breitenbach" wrote:

The =""""&a1&"""" doesn't work because it recognizes the entire string as
between quotes and results in a1 surrounded by the &, instead of the value in
a1 surrounded by quotes. The following works for me:
="''"&B5&"''"