Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

excel cut text with brackets from name

Posted on 2014-09-11
6
Medium Priority
?
139 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:Montoya
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 53

Accepted Solution

by:
Rgonzo1971 earned 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

926 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