Extract text left and right of character part 2

With the great help from here we cracked our first nutshell and I tried to use the first solution to overcome my next headache but it doesn't appear to work..

http://www.excelforum.com/excel-form...character.html

In essence we are trying to update 5000 templates with a new top and bottom so we thought if we extract the middle then add in the new top and bottom then this should overcome our template headache.

each template has a set of text characters that define the start and end so we know the bit in the middle is what we need.

for example.

<p><!-- ***************************************************************** Put your title in here ********-->
</p>
Middle template Info
<p>
<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ END of description @@@@ --></p>

So what we tried was to use the previous solution from part 1

=TRIM(LEFT(SUBSTITUTE(MID(AF19,FIND("|",SUBSTITUTE(AF19,"<!-- ***************************************************************** Put your title in here ********-->","|",1))+1,
LEN(AF19)),"<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ END of description @@@@ -->",REPT(" ",LEN(AF19))),LEN(AF19)))

But it doesn't seem to work at the front it is catching information prior to the <!-- ***************************************************************** Put your title in here ********-->

But it does seem to atleast on the small selection were testing on end at the right position.

<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ END of description @@@@ -->

Sure - lol its hard for you to read my eye's are hurting just looking at a few lines and I've got 5000 to do - lol

Its a very large file so I'll drop off the unwanted columns and upload a few rows to make it easier.

See attached a few lines showing on the left the full description and on the right what we had hoped would pull out the element we needed....

Sorry nope it pulled out part but less than the original.

<center><big> Scale 1:144<br><br>Excellent quality model kit

This is the bit I'm looking for.....

<!-- ***************************************************************** Put your title in here ********-->
</p>
<center>


<big> Panavia Tornado 04431 </big> </center>
</span></big></div>
</center><p>
<!-- $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ Put your images in here $$$$$ -->
<big> </big>
<center><big><br>


<img src="http://i435.photobucket.com/albums/qq74/gtspeed15/Aircraft/Academy/P1010005-1.jpg"></big></center>




<hr><br>
<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Start of description @@@@ -->

<center><big> Scale 1:144<br><br>Excellent quality model kit </big>

<p><!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ END of description @@@@ -->

My fault its a touch ahead of the start description

So if it pulls everything between.

<!-- ***************************************************************** Put your title in here ********-->

down to

<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ END of description @@@@ -->