Solved

# Excel -- Easy Formula ?

Posted on 2011-10-20
Medium Priority
211 Views
What Excel formula will get me column G ?

Basically I want to remove everything
before the "(" on 5000+ records.
s003.jpg
0
Question by:finance_teacher

LVL 50

Accepted Solution

barry houdini earned 668 total points
ID: 36999937
Try like this in G1

=REPLACE(F1,1,FIND("(",F1),"")

regards, barry
0

LVL 85

Assisted Solution

Rory Archibald earned 668 total points
ID: 36999945
Or:
=MID(F1,FIND("(",F1)+1,len(F1))
0

LVL 28

Assisted Solution

strickdd earned 664 total points
ID: 36999948
=MID(A1, FIND("(", A1) + 1, LEN(A1))
0

LVL 85

Expert Comment

ID: 36999978
Or:
=RIGHT(F1,LEN(F1)-FIND("(",F1))
0

LVL 24

Expert Comment

ID: 36999996
Could you do find ("*(") and replace ("")?

I wasn't sure if you had enough solutions.
0

LVL 85

Expert Comment

ID: 37000011
How many is enough? :)

=SUBSTITUTE(F1,LEFT(F1,FIND("(",F1)),"")
0

Author Comment

ID: 37000129
0

LVL 11

Expert Comment

ID: 37000317
This is why I always find it funny when you go into a temp agency and they test, to make sure you know Excel.  There are so many different ways to do things, the challenge is guessing what one they have marked as correct.
0

## Featured Post

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.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
###### Suggested Courses
Course of the Month13 days, 11 hours left to enroll