Programmer's Blog

Programmer's reference

Category Archives: Excel

[Excel] include double quotes in cell

Concatenating a double quote ” character is equivalently using 2 of the double quotes

="Hello ""name"" West"

gives Hello "name" West

=""""

gives one double quote i.e. "

=""""&"hello"&""""

gives "hello"