Concatenate quote symbol mystery?

[tekkendork]

I'm trying to bookend a column of cells within quotes using this formula:

="""&A1&"""

But you can see the problem with the quotes within quotes. Is there a special Excel symbol for quote marks for this to work?

[Leith Ross]

Hello tekkendork,

In a formula use CHAR(34) for a double quote. In VBA use Chr$(34) for the double quote.

  'Worksheet Formula
    = CONCATENATE(CHAR(34),A1,CHAR(34)

  'VBA Code
    Chr$(34) & A1 & Chr$(34)

Sincerely,
Leith Ross

[tekkendork]

excellent! Thanks much for your help