Excel formula to remove symbols?

[Karthik-Excelsior]

If I've a word like - "cheap shirts for sale" (quotation marks included) in a cell, I want Excel to give me a symbol-stripped version of the word. i.e., "cheap shirts for sale" (within quotations) >> excel formula >> cheap shirts for sale (without quotations). What's that 'excel formula'?

 

[adam087]

Try

=SUBSTITUTE(A1, """", "")
(assuming the original is in A1)

Regards
Adam

 

[VoG]

One way

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

 

[Karthik-Excelsior]

Thanks Adam & Peter! That really helps.. however, please pardon me for being shameless and asking a slightly varied version of my question:

If the word is something like - (cheap t shirts) - a pair of '()' instead of the double quotes, how to get rid of the parentheses using a formula?

 

[FishingIsMoreFun]

=MID(C8,2,(LEN(C8)-2))

C8 is the cell that holds the text.

Trims the first and last character only..nothing more.

 

[VoG]

Try

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

 

[Karthik-Excelsior]

Oh brilliant.. thx a ton, Peter! U rock and thx for making my today!