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.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.