Excel Formula | Search text between two specific cells or text

=IFERROR(MID($B2,FIND(J$1,$B2)+LEN(J$1)+1,FIND(":",MID($B2,FIND(J$1,$B2)+LEN(J$1)+1,LEN($B2)-FIND(J$1,$B2)+LEN(J$1)))),MID($B2,FIND(J$1,$B2)+LEN(J$1)+1,LEN($B2)-FIND(J$1,$B2)+1))


=IFERROR(MID(B2,FIND($K$1,B2)+12,LEN(B2)-FIND($K$1,B2)),"")