Putting double quotes around text

[masplin]

i have a formula in cell A2 with a text output. I need to add double quotes at beginning and end. however if I try to use this code i.e. a double quote inside a pair of double quotes as you would add any other text

="""&A2&"""

I just get this which isn't helpful

"&A2&"

<tbody>
</tbody>

is there some simple tweak so I get "Snow" if A2=Snow?

Thnaks
Mike

 

[JazzSP8]

You need;

=""""&A2&""""

(Four " each side)

 

[Joe4]

Try:

=""""&A2&""""

 

[masplin]

duh knew it was simple thanks

 

[jtakw]

Hi,

You can also do it this way:

=CHAR(34)&A2&CHAR(34)