If you notice, the entire text is surrounded by quotation marks. This tells the formula that everything inside those surrounding quotation marks is text. When Excel runs into the two quotation marks together, it processes it as a single quotation mark in the result..Because the text on either side of A consists of only of a double quote, you need “””” . The outer quotes tell Excel this is text, the nd ” tells Excel to .
0 Komentar