I am doing a special project in my work...my problem is i can find the
right command in elimininating some data from the data base provided to
me....here is the example...

Le Yuan [Jolin Tsai]
Ye Qu [Jay Chou]
Ai Mei [Rainie Yang]

I need to take out all the data in close parenthesis to match with my
data base in performing the look up function.

Here is the command i used courtesy of John Walkenback book, but my
problem is this command cant particulary identify the word in close
parenthesis only..

=IF(ISERR(FIND(" ",C24))," ",LEFT(C24,LEN(C24)-FIND(" ",C24,1)))

Thanks in advance for the help!!