View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
michelle michelle is offline
external usenet poster
 
Posts: 310
Default extracting text between two keywords

I have a block of wrapped text in cell D2. Buried within the text are two
keywords: "NAME:" and "CONSTRAINED". I want to extract all of the text
between these two keywords and paste it into cell L2.

I appreciate any help from the masses..
Thanks!