Extract words before the ( in a cell

[smithgt]

I've a cell containing PUFFER (#23), or LION (#16), EAGLE (#56)

What I want to be able to do is extract the word before the open bracket.

Do I need to use FIND and LEFT?

thanks

 

[vds1]

=trim(left(a2,find("(",a2)-1))

 

[dave3009]

If there is the possibility of there being no space inbetween the end of the word and the ( then try

=TRIM(LEFT(A15, FIND("(", A15)-1))

If there is always a space try

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

 

[smithgt]

Thanks all