| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel adds quotation marks when pasting text | Excel Discussion (Misc queries) | |||
| Quotation Marks as Text | Excel Discussion (Misc queries) | |||
| Generating text surrounded by quotation marks | Excel Discussion (Misc queries) | |||
| how do I concatenate text that has a quotation mark | Excel Discussion (Misc queries) | |||
| How do I concatenate text that actually contains quotation marks? | Excel Worksheet Functions | |||
Linear Mode
