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!!