Trim name from left of cell .

[Sunline]

Hello all ,

I am wanting to get a trim function that can give the results I have in col B .

Basically im needing to delete the numbers in brackets to the right but leaving the
name as well as retaining any name that has (AUS) , (GB) , (USA) , (SIN) .

Thanks .

Excel Workbook
	A	B
1	Name	Result
2	Carbonado (R1)	Carbonado
3	Coolibah (R1)	Coolibah
4	Cornelius (R1)	Cornelius
5	Edward The Eighth (R1)	Edward The Eighth
6	El Corby (R1)	El Corby
7	Iz (R1)	Iz
8	Fear Of God (AUS) (R2)	Fear Of God (AUS)
9	Ina Jam (GB) (R2)	Ina Jam (GB)
10	Steffi's Secret (R3)	Steffi's Secret
11	The Austrian Oak (R5)	The Austrian Oak
12	Checkoutthemisses (R6)	Checkoutthemisses
13	Dylan De Lago (R6)	Dylan De Lago
14	Fifty Shadz Famous (R6)	Fifty Shadz Famous
15	Spy In The Huddle (R6)	Spy In The Huddle
16	Zah Best (R6)	Zah Best
17	Elfee (R7)	Elfee
18	Jafa Jill (R7)	Jafa Jill
19	Overnightsensation (R7)	Overnightsensation
20	Delveen (AUS) (R8)	Delveen (AUS)
21	The Good Duke (USA) (R10)	The Good Duke (USA)
22	Victory Champion (R10)	Victory Champion
23	Zaviera (SIN) (R10)	Zaviera (SIN)
24	Absolutely Sacred (SA) (R13)	Absolutely Sacred (SA)
25	Lulu (R10)	Lulu
Sheet1

 

[Momentman]

Since you dont have a country like (RSA) or (RUS), this should work

Excel 2010
	A	B
1	Name	Result
2	Carbonado (R1)	Carbonado
3	Coolibah (R1)	Coolibah
4	Cornelius (R1)	Cornelius
5	Edward The Eighth (R1)	Edward The Eighth
6	El Corby (R1)	El Corby
7	Iz (R1)	Iz
8	Fear Of God (AUS) (R2)	Fear Of God (AUS)
9	Ina Jam (GB) (R2)	Ina Jam (GB)
10	Steffi's Secret (R3)	Steffi's Secret
11	The Austrian Oak (R5)	The Austrian Oak
12	Checkoutthemisses (R6)	Checkoutthemisses
13	Dylan De Lago (R6)	Dylan De Lago
14	Fifty Shadz Famous (R6)	Fifty Shadz Famous
15	Spy In The Huddle (R6)	Spy In The Huddle
16	Zah Best (R6)	Zah Best
17	Elfee (R7)	Elfee
18	Jafa Jill (R7)	Jafa Jill
19	Overnightsensation (R7)	Overnightsensation
20	Delveen (AUS) (R8)	Delveen (AUS)
21	The Good Duke (USA) (R10)	The Good Duke (USA)
22	Victory Champion (R10)	Victory Champion
23	Zaviera (SIN) (R10)	Zaviera (SIN)
24	Absolutely Sacred (SA) (R13)	Absolutely Sacred (SA)
25	Lulu (R10)	Lulu
Sheet1

Cell Formulas
Range	Formula
B2	=LEFT(A2,FIND("(R",A2)-2)

 

[Sunline]

Thanks Momentman , your function works perfectly .
I think i didnt abbreviate South Africa properly and should of put (RSA) .
Thanks again .