So to get the literal
"1"
the original poster wanted is possible very simply using ="""1""" rather
than weird concatenation he was using

Well, that is true if the 1 is hard-coded; but if the "1" were picked up
from a reference in another cell, then the full concatenation would be
required. For example, if A1 contained 1 as its contents, then another cell
displaying it quoted would need to use =""""&A1&"""". The main purpose
behind my post was to give insight as to why four quote marks in a row are
required to display a single quote mark... remember, my post was a follow-up
one to the last part of JE McGimpsey's posting and, by extension, a response
to MG's statement - What is the logic behind =""""? Specifically, that
statement about the four quote marks to display one quote mark is a question
that comes up from time to time over in the newsgroups devoted to the
compiled versions of Visual Basic; so I adapted my stock answer there for my
response here.

Rick