I have cell A and cell B
in Cell A I have string of text example: "Men's T-shirt (Small Black)"
Cell B says "Yes"

I want formula to do: if Cell B says YES, in cell A remove brackets and everything inside brackets leaving only rest of the text, how can I do this.
Thank you so much!