Literal quotation marks retained from a formula

  • Thread starter Thread starter Chappy
  • Start date Start date
C

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

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

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



--ron
 
Thanks to you both, very helpful!!

Chappy

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

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



--ron
Click to expand...
 
Back
Top