USING QUOTATION MARKS AS A TEXT STRING WITH THE CONCATENATE FUNCTION

[jbm]

I am trying to use the "concatenate" function to merge
the following three text strings:

"
any word
"

This would create the cell text:
"any word"

The problem seems to be that the quotation marks are a
special charater and therefore it will not perform the
function. Is there a special procedure for using the
quotation marks as a text string with the concatenate
function?

Thanks, John

 

[Peo Sjoblom]

Works fine for me

=A1&A2&A3

gives

"any word"

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Freemini]

You need to prefix the " with an apostrophe

hth

Mik

 

[Jonathan Rynd]

I am trying to use the "concatenate" function to merge
the following three text strings:

"
any word
"

The problem seems to be that the quotation marks are a
special charater and therefore it will not perform the
function. Is there a special procedure for using the
quotation marks as a text string with the concatenate
function?

Try
=CONCATENATE("""","any word","""")

the meaning of """" is as follows:
first ": begin quoted string
middle "": a literal " mark
end ": end quoted string

 

[JBM]

-----Original Message-----


Try
=CONCATENATE("""","any word","""")

the meaning of """" is as follows:
first ": begin quoted string
middle "": a literal " mark
end ": end quoted string
.

Thank you! That worked.