Ok, I am drawing a blank and I have spent 2 hours trying to figure out how I can do this in Excel and I beleive there is even a command for what I am looking for, but I am still can not figure it out. I will give you example of the data below. Basically I am looking to extract characters in the data, but I need it to search for the starting characters and then put that text all the way up to a certain word only. I know how to do it with the MID command, but the problem I have is that the MID command starts at X character and captures X amount of characters from that point forward. My data that I need to extract will be different lengths, but it will always begin with the same word and it will always end with the same word.

Here is 1 line of code that I need to extract. Technically there is going to be 25 lines like this per HTML file.

See were it says "contest_id..." that is were I want start to extract from and the last word I want it to go to is "Photoshop".

So on the example below it would extract the following information and put it in a cell. From that point I can create the web address again by merging cells.

contest.asp?contest_id=21345&display=photoshop

Example:

<tr bgcolor=''><td class='divider'><a href='/contest.asp?contest_id=21345&display=photoshop'><img style='width:75px' src='http://rookery1.plime.com/storage/41500/41707_e999_sqr.jpg' border='0' /></a></td><td class='divider'><a href='/contest.asp?contest_id=21345&display=photoshop' class='color4 td b'>Corrupted Innocence 5</a><br />When good things go very, very bad.</td><td class='divider'><span class='red4'>ended 10/13/2008</span></td><td class='divider'>30 entries</td></tr>


Thank you for your help!

RadicalROM