Explanation
To include double quotes inside a formula, you might use additional double quotes asescape characters.
By escaping a character, you are telling Excel to treat the " character as literal text.
You’ll also need to include double quotes wherever you would normally in a formula.
CHAR is handy for adding other text that is hard to work with in a formula as well.
CHAR can insert characters that are hard to enter into a formula.
