Thread: need help extracting data from cell....
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default need help extracting data from cell....
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,"(",""),")","")


Reply With QuoteReply With Quote