using an if statement with find to compute criteria

I am working on a rather large spreadsheet and I am trying to do this:

=IF(LEFT(H2,FIND(" ",H2))>E2,N,Y)

However, when I enter that in, Excel gives me a VALUE error and I don't understand why.

I even tried just putting in =LEFT(H2,FIND(" ",H2))>E2, to see what it would give me and it gave me all TRUE values, even after visual inspection some values are in fact supposed to be false.

Basically, is there a way for Excel to combine the IF and the FIND functions to look at a value in a cell composed of a number and text and extract the number. Then once the number is extracted, compare that to a value in another cell and give me "Y" or "N" if the criteria is met or not?

Thanks.

Btw, I love this forum.