Copy info before parenthesis or omit info after

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Thank You for your quick reply!!
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 :-?
 
Upvote 0
Is the only thing following the name a space and the 2 letters? If so, try
=LEFT(A1,LEN(A1)-3)
 
Upvote 0
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
 
Upvote 0
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:
 
Upvote 0
there may be some extra spaces you are picking up, try
=LEFT(A10,LEN(TRIM(A10))-3)
 
Upvote 0
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 :o
 
Upvote 0

Forum statistics

Threads
1,226,698
Messages
6,192,514
Members
453,728
Latest member
Ishtiak Mahmud

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top