Recently I faced a challenge to concatenate a double quote in the string. The formula =CONCATENATE(“”",A1,”"”) did not worked. After some research I found out that it can be entered as

=CONCATENATE(“”"”,A1,”"”")

and bingo! it worked…simply add 4 double quotes!