How to Trim Once Open Parenthesis Appears

[meppwc]

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

 

[Fluff]

How about
=LEFT(A1,FIND("(",A1&"(")-1)

 

[meppwc]

Thanks a bunch Fluff

 

[Fluff]

You're welcome & thanks for the feedback

 

[Rick Rothstein]

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

If you would like to do this to your original data (that is, perform the removal directly within the data cells themselves), simply select the column or columns containing your data, press CTRL+H to bring up the "Replace" dialog box, put (* in the "Find what" field, leave the "Replace with" field empty and click the "Replace All" button.