USING QUOTATION MARKS AS A TEXT STRING WITH THE CONCATENATE FUNCTION

J

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
 
P

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)
 
J

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top