This formula finds the left bracket and takes characters to there.
=LEFT(A1,FIND("(",A1)-1

--
Brian

-----------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...tinfo&userid=5
View this thread: http://www.excelforum.com/showthread.php?threadid=38828