Literal quotation marks retained from a formula

[Chappy]

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]

=""""&"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.

 

[Ron Rosenfeld]

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

 

[Chappy]

Thanks to you both, very helpful!!

Chappy

You just replace the ( and } with doubled ""'s:

=""""&"0"&'Raw Numbers'!A7&""""&" "&"OR"&" "&""""&'Raw Numbers'!B7&""""



--ron