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 C3000(10.28.132.53)
In B1-B3 I want to end up with:
Aficio MP C3502
MP C307
IM C3000
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 C3000(10.28.132.53)
In B1-B3 I want to end up with:
Aficio MP C3502
MP C307
IM C3000