Assistance required

[mdb231]

Hi all I am into horseracing and download results via a program which someone did for me, the thing I would like assistance with, is when the names get downloaded they are have in brackets following the name the country where the horse is bred.,but when I do a search it can miss some because of this.
Is there a macro or something that will take these off so all that is left is the name or the horse.
Any help appreciated.
Michael

 

[mdb231]

Hi Peter_SSs
Yes that is what was needed. I didn't think I'd be able to do that so didn't mention it, so a bonus for me.
Thanks

 

[Peter_SSs]

Hi Peter_SSs
Yes that is what was needed. I didn't think I'd be able to do that so didn't mention it, so a bonus for me.
Thanks

You are welcome. Glad to contribute.