ExcelBanter - extracting text between two keywords

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - extracting text between two keywords (https://www.excelbanter.com/excel-worksheet-functions/220398-extracting-text-between-two-keywords.html)

michelle

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!

All times are GMT +1. The time now is 09:57 PM.