Post some example strings (better yet a file with strings within).

The key will be whether or not other text appears within the string(s) which is to be ignored / irrelevant

In the most general of terms you can use the Split Function to separate the string (populate a Variant array) based on the hyperlink tag.
However, if there is surplus text to be accounted for then the Split approach will most likely require further adaptation.

Without examples it's hard to give anything more specific I'm afraid.