Use Quotes in Concatenate

  • Thread starter Thread starter tazdev
  • Start date Start date
T

tazdev

I searched but could not find the answer then Boom I stumbled upon it o
my own. Anyway here it is:

To use Quotes in a CONCATENATE formula use two quotes next to eac
other. I am sure most here knew that but I have been using Excel for
looooong time and never knew that since I never needed to know it :)

Example:
Combine Cell A1 and Cell B1 and Quotes
A1=Blah B1=hlaB


=CONCATENATE("""",A1,""",",B1)
Results:
"Blah",hlaB

Anyway this is in case someone does a search for something like thi
:)
 
Taz Devil,

To expand on this a little, when you want quotes inside of quotes, double
them up. It has nothing to do with Concatenate, actually. """" is one
quote inside a pair of quotes.

"Mack ""The Knife"" Heath."
would be interpreted as
Mack "The Knife" Heath.

Two consecutive quote marks in a quoted string don't end the quote string,
but means there's one quote there. A single quote ends the string.

Hope this helps.
 
Back
Top