Terry,

The following formula will remove the bracket part of a name in A2. It
allows for an optional space before the left parenthesis.

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

If it is guaranteed that there will always be a space before the
parenthesis then you can use the simpler formula:

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

HTH
Kostis Vezerides