Single and Double Quotes

[Siddharth Ananthula]

Hello Gentlemen.

I have problem removing single and double quotes that encompass my text in each cell of the excel. Attached is a sample file. Can you please advise on how to detach each with an automatic formula. thank you.


Sid

 

[NARAYANK991]

Hi Siddharth ,

Something like this ?

=SUBSTITUTE(SUBSTITUTE(A2,"'",""),"""","")

Narayan