Open your spreadsheet in Microsoft Excel ... unquoted words "hall" and "mark," the result would be "hallmark" without quotes. If the text in cells A1 or A2 already has double quotation marks ...

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