Thread: need help extracting data from cell....
View Single Post
  #2   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....
hi Chris,

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


--
isabelle

Reply With QuoteReply With Quote