extracting text between two keywords
Perfect..Thank you
"Gary''s Student" wrote:
Put the string in A1
Put the first keyword in A2
Put the second keyword in A3
In A4 enter:
=MID(A1,FIND(A2,A1)+LEN(A2),FIND(A3,A1)-FIND(A2,A1)-LEN(A2))
for example:
wkhf78fhjaNAME:123456789CONSTRAINED987vos
NAME:
CONSTRAINED
123456789
--
Gary''s Student - gsnu200832
"Michelle" wrote:
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!
|