If you want to insert a parenthesis into an excel formula (for example, concatenating strings into something to export), you want do use double-double-quotes:

"I am ""cool"""

Produces the text string I am “cool”

A useful example is producing email addresses:

=CONCATENATE("""",A2, """ ")