Excel 2003 Guru?

[RadicalRom]>USK<[]

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>

[Kethoth]>USK<[]

support.microsoft.com/kb/214142/en-us?spid=2512&sid=293


maybe that will help if not i'll ask my teacher friday if i can remember

[RadicalRom]>USK<[]

Thanks Kethoth! What I ended up doing is cheating. I did this as a macro in Excel. It first did a find/replace and I found the word PHOTOSHOP and then replaced it with PHOTOSHOP and a space on the end of the word. Then I used the MID command because I found that the number of characters was the same at the start. I grabbed 5 more characters then I needed, just in case the field become bigger in the future. Then I had a field that looked good, but it had to much extra characters on the end, including the famous PHOTOSHOP with a space. The space is what I am keying off of to trim the right side of it and my formula ended up looking something like this: =LEFT(A3,FIND(" ",A3)-1)

Basically what this does is looks at that line and when it finds the space it removes the space and trims everything to the right side. I know this is not the pretty way of doing it but it was one way of doing it, lol.