Trim the name from mid

[Sunline]

Hello all ,

I am needing to get a function or two that can give me the results I have in col BQ .

The name is always to the immediate left of the number in brackets .
The name will not contain any numbers at all .

I am looking to get the exact result but if I can get very close that will be fine .

Thanks .

Excel Workbook
	BP	BQ
1	FHBASC	Result
2	1. * 98443 Cornelius (2) 5.0 g b	Cornelius
3	2. * 31315 El Corby (6) 5.0 g b	El Corby
4	3. * 75323 Coolibah (4) 5.0 g b	Coolibah
5	4. * 61444. Nancylee (5) 5.0 m ch	Nancylee
6	5. * 00x75 Carbonado (7) 8.0 g blk	Carbonado
7	6. * 60160 Iz (1) 5.0 g b	Iz
8	7. * 18845 Edward The Eighth (3) 5.0 g b	Edward The Eighth
9	1. * 4093 All Zedin Done (2) 6.0 g br	All Zedin Done
10	2. * 59x63 Politicalnitemare (13) 4.0 g b	Politicalnitemare
11	3. * 56734 Varro (5) 6.0 g b	Varro
12	4. * 00207 Sir Al Syd (9) 9.0 g b	Sir Al Syd
13	5. * 04058 Absolute Gem (10) 5.0 g b br	Absolute Gem
14	6. * x5606 Bad Taste (7) 6.0 g b	Bad Taste
15	7. * 00078. Captain Earnie (8) 4.0 g ch	Captain Earnie
16	10. * 60. Mojave (6) 4.0 g ch	Mojave
17	11. * 26250 Chloe Keeper (11) 7.0 m b	Chloe Keeper
18	12. * 36435 Ina Jam (12) 4.0 m b	Ina Jam
19	13. * 55 Chumana (4) 4.0 m ch	Chumana
20	14. * 06906 Izzanorange (3) 5.0 m ch	Izzanorange
21	1. * 97907 Billie Jean King (3) 6.0 m b	Billie Jean King
22	2. * 153x3 Cape Mapperley (1) 4.0 m ch	Cape Mapperley
23	3. * x0013. Steffi's Secret (7) 4.0 m br	Steffi's Secret
24	4. * 1. High Tail It (4) 4.0 m br	High Tail It
25	5. * 90636 Belinda's Girl (5) 8.0 m b	Belinda's Girl
26	6. * 51940 Amber Rayne (8) 3.0 f b	Amber Rayne
27	7. * 91090 Our Queen Bee (6) 4.0 m blk	Our Queen Bee
28	8. * 866. Lola Brigida (2) 6.0 m b	Lola Brigida
29	2. * 38x Indian Giva (4) 3.0 g ch	Indian Giva
30	3. * Dartmoor (12) 3.0 g b	Dartmoor
31	4. * Mongolian Hero (8) 3.0 c b	Mongolian Hero
32	5. * Thewayyourave (11) 3.0 g b	Thewayyourave
33	7. * Elfee (13) 3.0 f br	Elfee
34	8. * Mary Quant (10) 3.0 f b	Mary Quant
35	9. * Sea Of Speed (9) 3.0 f gr	Sea Of Speed
36	20. * 9x Zah Best (10) 3.0 f b	Zah Best
37	1. * 4632 Heeza Dreimer (12) 5.0 g b	Heeza Dreimer
38	2. * 0x363 Justabout Ready (16) 4.0 g br blk	Justabout Ready
39	3. * 8465 El Sparky (6) 5.0 g gr	El Sparky
40	5. * 532. Chasing Amy (4) 4.0 m b	Chasing Amy
41	7. * 53528. Gold Vault (10) 5.0 m b	Gold Vault
42	7. * 5826. Mary Magdalene (7) 4.0 m b	Mary Magdalene
43	8. * 4x0x0 Oh So Famous (5) 4.0 m ch	Oh So Famous
44	3. * 3020x Esprit D'Or (5) 9.0 g b	Esprit D'Or
45	4. * 08483. Fiddler's Green (2) 10.0 g b	Fiddler's Green
46	5. * x8980. Comanche Gold (3) 7.0 g ch	Comanche Gold
47	6. * 024x9. Terelle (8) 6.0 g ch	Terelle
48	8. * 89x94. Ima Dude (7) 8.0 g b	Ima Dude
49	9. * 71154 Irish Excuse (6) 4.0 g b	Irish Excuse
50	15. * 02069. Sir Jack Remington (1) 5.0 g b	Sir Jack Remington
17-9-14 AVON GORE

 

[pgc01]

Hi

Try this udf. In BQ2:

=GetName(BP2)

Function GetName(s As String) As String

With CreateObject("VBScript.RegExp")
    .Pattern = " [ a-zA-Z']+(?=\()"
    If .test(s) Then GetName = Trim(.Execute(s)(0))
End With
End Function

 

[Sunline]

Thank you pgc01 , this is exactly what i needed .
Thank you .

 

[pgc01]

You're welcome. Thanks for the feedback.