I have a bunch of cells that I need to trim off everything once and open parenthesis is found, including the open parenthesis
Is there a formula that will do this?
I have a few examples below
The below 3 examples are in A1-A3
Aficio MP C3502(10.28.132.33)
MP C307(10.28.132.58)
IM...