Need help clean strings

[fredrerik84]

Hello great community. I have some strings I need to clean. Here is some samples:

leagueData('39290','ROUND 16','UZBEKISTAN','C','2016/2017','FA CUP'); return false;
leagueData('37935','ROUND 64','ARGENTINA','C','2016/2017','FA CUP'); return false;
leagueData('41003','STAGE 1','SOUTH AMERICA (CONMEBOL)','C','2016/2017','COPA SUDAMERICANA'); return false;
leagueData('37964','ROUND 16','ASIA (AFC)','C','2016/2017','AFC CHAMPIONS LEAGUE'); return false;

Any help with a vba code to get it to only return the text in red ?

The string is stored like this

Dim Leaguedata as string 
Dim r as Long 

and I have a loop which returns the results from above.

any help would be really appreciated

 

[fredrerik84]

thank you , just perfect