# Copy info before parenthesis or omit info after

#### daniels012

##### Well-known Member
In Column A, I have data such as:
Michael Tollison (SF-RB) 26 25 25%
All I want in column B is the name to the left of the parenthesis.
Everything in column a always is set this way, so the name is
first.

What can I write for a formula to extract this name easily?

Michael

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
=TRIM(LEFT(A1,FIND("(",A1)-1))

That will work perfectly.

I have another 6 sheets that don't have parenthesis. There is something unique though. After every name there is a 2 letter code. Like in my example I used before, There is "SF". Can I use your same method you supplied me with, but look for 2 capital letters???

I am sorry to be a pain, but I thought all pages were the same. Otherwise, I am going to have to separate many, many records individually.

Thank You,
Michael

Is the only thing following the name a space and the 2 letters? If so, try
=LEFT(A1,LEN(A1)-3)

No that did not work. It did not do anything??
Your first formula worked great with the parenthesis. Thank You!!!!!

I am not sure how I can write this to get the left side of the 2 capital letters??

Michael

There are 2 spaces before the 2 capital letters. Is there something I can write to enter this?

Walter Tollison SF ie:space after Walter and space after Tollison

Michael :wink:

there may be some extra spaces you are picking up, try
=LEFT(A10,LEN(TRIM(A10))-3)

Nope!
Still giving me the whole thing.

Any other ideas?

Michael

I think if I can write code that will find the 2nd blank, and then print to the left, It will work!!

Don't know though??

Michael

Could I use the SUBSTITUTE function with this problem??

Michael

Replies
6
Views
228
Replies
5
Views
112
Replies
2
Views
351
Replies
1
Views
264
Replies
11
Views
316

1,203,174
Messages
6,053,920
Members
444,694
Latest member
JacquiDaly

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back