How to Trim Once Open Parenthesis Appears

meppwc

Active Member
Joined
May 16, 2003
Messages
422
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
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,606
Office Version
365
Platform
Windows
How about
=LEFT(A1,FIND("(",A1&"(")-1)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,606
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,906
Office Version
2010
Platform
Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,000
Messages
5,465,943
Members
406,453
Latest member
MarkB5432

This Week's Hot Topics

Top