Removing apostrophies from a string

Hi!

I have this rather beautiful formula that someone very kindly helped me compile a while back for cleaning a string which is copied in externally.

=TRIM(IF(ISERROR(SEARCH("(",K34)),TRIM(LEFT(SUBSTITUTE(K34," ",REPT(" ",255)),LEN(SUBSTITUTE(K34," ",REPT(" ",255)))-255)),LEFT(SUBSTITUTE(K34,"(",REPT(" ",255)),255))))&"

I've been trying to add in the function to also remove apostrophies from the string as well but to no avail so I am pleading for help! I'd like them to be deleted entirely, including the space and not substituted for anything.

Big TIA!!

Sorry, you've lost me at the dq bit... am I being thick?

He's just trying to make it clear what the text is. dq = double quote; a = appostrophe. You don't actually type the help in the parentheses.

haha I knew I was being thick! Thanks!!