Extracting variable data based upon fixed criteria.

[GGK]

Hi,

I'm looking to create a spreadsheet where I can paste a large amount of data that is received from a notepad file (*.txt) and then create a formula that will take specific info from that pasted data and transfer it into a new cell.

In this example, I receive the following text file:

<SATURDAY VOTES="Michigan State 154, Houston 68, Washington 37, Texas Tech 25, Notre Dame 24, South Florida 22, Georgia 11, Penn State 9, USC 7, Southern Methodist 5, Cincinnati 1, Pittsburgh 1, Tennessee 1">
<oVERNIGHT VOTING>
<CALCULATING>
<SUNDAY VOTES="Michigan State 130, Houston 99, Washington 87, Texas Tech 45, Notre Dame 23, South Florida 17, Georgia 9, USC 4,;MAC=[one game left to play]">
<MONDAY VOTES="Michigan State 110, Houston 67, Washington 37, Texas Tech 25, Notre Dame 11;MAC=[Final Voting];Number1 team=[undecided]">
</Week 6>
</Calculate>


What I would like to do... is paste the Entire Text file in an Excel Cell and then be able to create a formula that extracts "specific data" that lies between 2 constants in the text file.

In this example.. I would like my new cell to display the info for MONDAYS VOTES... Specifically this new cell will only display the following:

Michigan State 110, Houston 67, Washington 37, Texas Tech 25, Notre Dame 11

So i'm only asking for the exact data that falls within the first " after MONDAYS VOTES="***************************; and up to.. but NOT including the ;

Thank you in advance for your help.

GGK

 

[GGK]

sorry... it looks like my text file didn't paste properly... this is the data that i receive and need to parse.

SATURDAY VOTES="Michigan State 154, Houston 68, Washington 37, Texas Tech 25, Notre Dame 24, South Florida 22, Georgia 11, Penn State 9, USC 7, Southern Methodist 5, Cincinnati 1, Pittsburgh 1, Tennessee 1"
*OVERNIGHT VOTING*
*CALCULATING*
SUNDAY VOTES="Michigan State 130, Houston 99, Washington 87, Texas Tech 45, Notre Dame 23, South Florida 17, Georgia 9, USC 4,;MAC=[one game left to play]"
MONDAY VOTES="Michigan State 110, Houston 67, Washington 37, Texas Tech 25, Notre Dame 11;MAC=[Final Voting];Number1 team=[undecided]"
Week 6
Calculate

------------------

So i'm only asking for the exact data that falls within the first " after MONDAYS VOTES="***************************; and up to.. but NOT including the ;

and this is what the NEW CELL should produce:

Michigan State 110, Houston 67, Washington 37, Texas Tech 25, Notre Dame 11

Thank you in advance for your help.

GGK