Thread: Cell Range Split into Multiple Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
  
Posts: 587
Default Cell Range Split into Multiple Cells
hi Willie,

=MID(A1,SEARCH("is",A1)+3,SEARCH(", change",A1)-SEARCH("is",A1)-3)

--
isabelle

Reply With QuoteReply With Quote