Hi,

Does anyone know how to copy the contents of a cell to another and
remove any "quotes" that may be present?

I am able to replace brackets using the function below - however this
just throws up an error when trying to remove " :

=SUBSTITUTE(SUBSTITUTE(A1,")",""),"(","")


cheers,

Jon