how to copy contents of a cell and remove any quotes " "

J

jonny

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
 
R

RichardSchollar

Hi Jon

As regards a formula approach, then you just need to be a bit careful
(as you've found) as Excel considers the " to end the string. So you
need additional " characters:

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

Hope this helps!

Richard
 
Top