I'm looking for some help with a formula - I'm trying to remove the brackets and text contained within the brackets but I have various scenarios - I've managed to get a formula which removes the brackets but it only works in the first scenario from the examples in the image below ie where there is only 1 set of brackets but there are scenarions where there are multiple sets of brackets - where there is more than 1 set, I want to keep the first set of brackets with the text.
The formula I was using is below.
I would really appreciate any help you guys can offer
=IFERROR(LEFT(AK2,FIND(CHAR(1),SUBSTITUTE(AK2,"(",CHAR(1),LEN(AK2)-LEN(SUBSTITUTE(AK2,"(",""))))-1),AK2)
The formula I was using is below.
I would really appreciate any help you guys can offer

=IFERROR(LEFT(AK2,FIND(CHAR(1),SUBSTITUTE(AK2,"(",CHAR(1),LEN(AK2)-LEN(SUBSTITUTE(AK2,"(",""))))-1),AK2)