IF function where the first result returns #VALUE

I’ve got the following in Column A:

112234
113456(Producer)
123211
114523(Producer)
224431(Producer)

I want to create a Column B and a Column C that separates this out to:

112234
113456         (Producer)
123211
114523         (Producer)
224431         (Producer)

So I put this IF statement in Column B, but it gives me a #VALUE for the 1st and 3rd records:

=IF(FIND("(",A2)>1,LEFT(A2,FIND("(",A2)-1),A2)

Can anyone tell me what I’m doing wrong?

>Solution :

FIND() returns an error when what you are looking for isn’t found, not 0.

Try this instead.

=IF(ISERROR(FIND("(",A2)),A2,LEFT(A2,FIND("(",A2)-1))