Microsoft Excel uses double quotation marks to signify text within formulas. When it sees these marks, it uses the text and discards the quotes. Typing quotation marks directly into a cell is not ...

Excel then uses the text within quotes but discards the quotation marks. This poses a problem when you actually need to concatenate the double quotation marks themselves.