| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
