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

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

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

Did you consider the find and replace command on the edit menu?

"jonny" wrote:

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

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

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

On 28 Jan, 18:14, "jonny" wrote:
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