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

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

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

="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)&";"



jkrons wrote:

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

--

Dave Peterson

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

Thanks. I tried that, but must have done sometinh wrong as I kept on getting
an error. Now it works fine though.

Jan

Dave Peterson wrote:
="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)&";"



jkrons wrote:

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

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

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

Jan Kronsell wrote:

Thanks. I tried that, but must have done sometinh wrong as I kept on getting
an error. Now it works fine though.

Jan

Dave Peterson wrote:
="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)&";"



jkrons wrote:

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

--

Dave Peterson