If you only want to have

"1"

in a cell, then just type it in that way. No need for a formula (i.e.,
don't start it with a '=').

However, if you want a formula, you need to account for XL using "x" as
an indication that x should be treated as Text. If x is omitted, you get
the null string

""

To differentiate between the quotation marks at the beginning/end of a
string and quotation marks that are part of a string, XL's syntax
requires that the latter be doubled:

"this "" will display a quotation mark within this string"

If the quotation mark is the only text within the string, then it looks
like

""""





In article ,
MG wrote:

What is the logic behind ="""" & ="r"

When we need to have "1" in a cell, we need to type = """"&1&""""

Your input will be appreciated