excel formula - find and remove all text after "char" if it exists not working if "char" doesn't exist

Hi all

I have what I thought would be a very basic Excel formula to remove all text after a certian character, but I get the #VALUE! error if the character doesn't exist and I can't work out how to resolve.

In my case I want to I want to remove all characters after "("

This is a samle of a couple of the cells and what I want to see:

existing column cleaned colum

joe brown (343464) joe brown

fred smith fred smith

the formula I'm using is:

=LEFT(E5,FIND("(",E5)-2)

the problem is that if "(" does not exist e.g. in the fred smith row, I get #VALUE! error, I have tried using =IF(FIND("(",E3)>1,"1","0") but that gives the same error.

How can I resolve this?

Thanks