Formula needed to retrieve name only

Hi,
I receive a roll call of names where the name is followed by a bracket or hyphen and a number, or both. I need to extract the name only in a separate column.
Can someone please be so kind and assist me with a formula to do this. Examples are shown in the attachment.
Many thanks in anticiaption
Mikey

Hi...This may help

=LEFT(E3,(IFERROR(SEARCH("(",E3)-1,(SEARCH("-",E3)-1))))

Have checked my full list and there are only three people with hyphens in their names, so will take out the hyphen manually. Is this what you mean or is there a problem in distinguishing between the hyphen and the bracket.

Hi, have marked thread as solved but when I input into my full list I have a slight problem in that new recruits have not as yet been allocated a number so they are name only. These now appear as #value in my second column. How can I change this.
Rgds
Mikey

oh...sorry, i didnt considered the case of "names only", use the below revised formula

=(IFERROR(LEFT(E3,(IFERROR(SEARCH("(",E3)-1,(SEARCH("-",E3)-1)))),E3))

Let me know if this works

Thanks works superbly. Should have put in the names only in the first instance. Thanks
for coming back to the thread even after I had put solved.
Very much appreciated
Mikey