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