On Oct 19, 1:36*pm, isabelle wrote:
or,

=IF(ISERROR(FIND("(",A1)),A1,LEFT(A1,FIND("(",A1)-1))

--
isabelle

Le 2011-10-19 14:33, isabelle a écrit :







hi Chris,

=SUBSTITUTE(SUBSTITUTE(A1,"(",""),")","")

OR withOUT formulas, Just use datatext to columnsdelimitedother (