Friday, January 11, 2008

Concatenate a double quote in Excel formula

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...