| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Literal quotation marks retained from a formula
Hi,
I have a formula and as part of the output I wish to insert quotation marks. The output of the formula will be used as a search string within Google, hence the need for the quote marks. The old formula was similar to: ="("&"0"&'Raw Numbers'!A7&")"&" "&"OR"&" "&"("&'Raw Numbers'!B7&")" where we referenced cell a7, b7 etc. What I wish to do is to remove the ()characters and replace them with a " instead so that instead of having an output of a number like (123456789) we have "0123456789" etc. Thanks, Chaps |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Literal quotation marks retained from a formula
=""""&"0"&'Raw numbers'!A7&""""&" "&"OR"&" "&""""&'Raw numbers'!B7&""""
or =char(34)&"0"&'Raw numbers'!A7&char(34) &" "&"OR"&" "&char(34)&'Raw numbers'!B7&char(34) Double up the quotes inside strings--or use char(34) to represent one double quote. Chappy wrote: Hi, I have a formula and as part of the output I wish to insert quotation marks. The output of the formula will be used as a search string within Google, hence the need for the quote marks. The old formula was similar to: ="("&"0"&'Raw Numbers'!A7&")"&" "&"OR"&" "&"("&'Raw Numbers'!B7&")" where we referenced cell a7, b7 etc. What I wish to do is to remove the ()characters and replace them with a " instead so that instead of having an output of a number like (123456789) we have "0123456789" etc. Thanks, Chaps -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Literal quotation marks retained from a formula
On Mon, 4 Feb 2008 18:13:02 -0800, Chappy
wrote: Hi, I have a formula and as part of the output I wish to insert quotation marks. The output of the formula will be used as a search string within Google, hence the need for the quote marks. The old formula was similar to: ="("&"0"&'Raw Numbers'!A7&")"&" "&"OR"&" "&"("&'Raw Numbers'!B7&")" where we referenced cell a7, b7 etc. What I wish to do is to remove the ()characters and replace them with a " instead so that instead of having an output of a number like (123456789) we have "0123456789" etc. Thanks, Chaps You just replace the ( and } with doubled ""'s: =""""&"0"&'Raw Numbers'!A7&""""&" "&"OR"&" "&""""&'Raw Numbers'!B7&"""" --ron |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Literal quotation marks retained from a formula
Thanks to you both, very helpful!!
Chappy "Ron Rosenfeld" wrote: On Mon, 4 Feb 2008 18:13:02 -0800, Chappy wrote: Hi, I have a formula and as part of the output I wish to insert quotation marks. The output of the formula will be used as a search string within Google, hence the need for the quote marks. The old formula was similar to: ="("&"0"&'Raw Numbers'!A7&")"&" "&"OR"&" "&"("&'Raw Numbers'!B7&")" where we referenced cell a7, b7 etc. What I wish to do is to remove the ()characters and replace them with a " instead so that instead of having an output of a number like (123456789) we have "0123456789" etc. Thanks, Chaps You just replace the ( and } with doubled ""'s: =""""&"0"&'Raw Numbers'!A7&""""&" "&"OR"&" "&""""&'Raw Numbers'!B7&"""" --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Quotation Marks | Excel Discussion (Misc queries) | |||
| Quotation Marks? | Excel Worksheet Functions | |||
| without quotation marks? | Excel Discussion (Misc queries) | |||
| Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
| Use quotation marks in a formula to display a qty in feet and inc. | Excel Worksheet Functions | |||
Linear Mode
