Solved

excel cut text with brackets from name

Posted on 2014-09-11
6
108 Views
Last Modified: 2014-09-11
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
0
Comment
Question by:Mandy_
6 Comments
 
LVL 19

Expert Comment

by:Iammontoya
ID: 40316938
so you simply want to delete the text between the parentheses, including the parentheses?
0
 
LVL 19

Expert Comment

by:helpfinder
ID: 40316944
text to columns applied on B2 with delimiter set as left bracket
result will be as in sample attached
sample.xlsx
0
 
LVL 2

Author Comment

by:Mandy_
ID: 40316959
including the parentheses
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 19

Expert Comment

by:helpfinder
ID: 40316971
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
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40316981
pls try

=UPPER(IFERROR(MID(B2,1,FIND("(",B2)-1),B2))
0
 
LVL 2

Author Closing Comment

by:Mandy_
ID: 40318603
Thank you so much.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now