Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |