How do I get a text to contain a quotation sign?

  • Thread starter Thread starter jkrons
  • Start date Start date
J

jkrons

O have this formula: ="Subject is=";"&" "&ProductH3&" "ProductsI3&"
"&Products!J3&" "&";""

What I would like is it to display in the cell as

Subject is =";First time order";

Where First, Time and Order comes from the cells in Products. But I
have problems getting Excel to display the qoutationmarks as
quotationmarks.

First text shoud be hardcodes as Subject is =";
Last text should be ";

Regards
Jan
 
="Subject is="";"&Products!H3&" "&Products!I3&" "&Products!J3&""";"

In general, you double up those quotation marks within strings.

If it gets too frustrating, you can use =char(34) to represent that double
quote:

="Subject is="&CHAR(34)&";"&Products!H3
&" "&Products!I3&" "&Products!J3&CHAR(34)&";"
 
Thanks. I tried that, but must have done sometinh wrong as I kept on getting
an error. Now it works fine though.

Jan
 
You had a few typos in the formula you posted--maybe that was part of the
problem.
 
Back
Top