excel cut text with brackets from name

I'm getting in sheet1   TARGAS FORREA, JOSE LUIS (INTERN)  

with      =GROSS(sheet2!$B2)

How could i cut always the text with brackets in sheet B2?

for the example should be       TARGAS FORREA, JOSE LUIS
LVL 2
Mandy_Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Rgonzo1971Connect With a Mentor Commented:
pls try

=UPPER(IFERROR(MID(B2,1,FIND("(",B2)-1),B2))
0
 
MontoyaProcess Improvement MgrCommented:
so you simply want to delete the text between the parentheses, including the parentheses?
0
 
helpfinderIT ConsultantCommented:
text to columns applied on B2 with delimiter set as left bracket
result will be as in sample attached
sample.xlsx
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Mandy_Author Commented:
including the parentheses
0
 
helpfinderIT ConsultantCommented:
or simply mark all cells which you want to remove parentheses. Use Replace feature (press ctrl+H) and type (*) - type exactly asterisk in parentheses and "replace with" field leave blank as it is by default
0
 
Mandy_Author Commented:
Thank you so much.
0
All Courses

From novice to tech pro — start learning today.