Substitute with multiple characters

[JimM]

Hi
I need to strip some specific characters from cells of text eg if the cell contents was

A blue dog (canine) was called spot's

I need to strip the ( ) & ' so it would read

A blue dog canine was called spots

I know I can use multiple substitute statements but is there a way to do it in one go, tried

=SUBSTITUTE(A1, {"(",")","'"},"") but that spills the result

Thanks

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[JimM]

Sorry, using Excel365, I'll update details my shortly

 

[Fluff]

In that case how about

=CONCAT(TEXTSPLIT(A2,{"(",")","'"}))

 

[JimM]

That's worked a treat. Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.