Combine fields containing quotes

  • Thread starter Thread starter ZenMasta
  • Start date Start date
Z

ZenMasta

I am trying to combine several fields into one.

Currently my formula looks something like this
=D3&"Some text "&E3&" <br><b>more info: </b>"&F3

This all works just fine, except sometimes I'll need to insert html more
advanced than a simple bold or break. How do I escape the quotes in my html
so they don't affect the formula?

=D3&"Some text "&E3&" <br><b>more info: </b>"&F3&Q3

For now I have just simply added my html in another field and appending it
this way. It would still be nice to know if it is possible to escape quotes.
 
ZenMasta said:
How do I escape the quotes in my html so they don't affect the formula?
Click to expand...

I am a little confused. A concrete example be nice.

If you are asking how you insert a double-quote into text, the answer is "".
For example:

"this is ""surrounded by"" double quotes"

But the HTML for double-quotes is "&quote;" (without quotes). For example:

"this HTML is &quote;surrounded by&quote; double quotes"

However, I don't see what that has to do with "appending it this way",
referring to &Q3 in your formula. If you know how to put the double-quote
(either form) into Q3 (implied by your saying "for now I have just simply
added my html in another field"), you should know how to put into your
formula.


----- original message -----
 
Back
Top