Extract text between certain characters

I have a spreadsheet containing a lot of text values (see attached). I'm trying to extract certain text from between a specific set of characters and copy the value to a unique cell (on a new sheet?). One issue is that I don't know how to extract between specific characters - some version of MID or TRIM? Another issue is that there are hundreds of these values I need contained in only 37 cells. I need each extracted to a unique cell.

Eg. I want to extract "test123" from between <li data-value= >

<li data-value="test123">


let me know if you have any questions and thank you for any help!

Don't understand fully.

You said that you're trying to extract certain text...does that mean that you know that those text/string are?

If you do, can't you use a MID and FIND function?

Sorry let me clarify. I have hundreds of unique values that I'm trying to extract. All of these values are surrounded by the same characters that I don't want included. I'm trying to extract the unique values from inside these characters.

Eg:
<li data-value="Cox - The Bone Online" class="">
<li data-value="Crash Media - Bike Sport News" class="">
<li data-value="Deskfive - OdaTV" class="">

In the examples above, I want to extract the red text and put them in unique cells. I know the <li data-value= and class=""> within the spreadsheet are constant and always present for the text I'm trying to extract. All 3 lines of text are contained within the same cell in excel.

Thanks for taking a look