Extracting a specific string from all cells?

How does one extract a specific sting/words from each cell?
Especially if [formatted data] varys in characters (not suitable for regular LEFT, MID, RIGHT functions use).

Take a look at the attachment.

Sample Question.xlsx

Try =MID(A2,SEARCH(".html",A2)-6,6)
Does that work for you?

Yes. Thank you. I am sending oceans of reps right now.

So essentially what this function does is?
=MID[TargetCell, Search("specificstring",targetcell)-???, return 6 characters)?

Search returns the starting position of a string or a single character. We use it to find where we want to extract our 6 characters using MID
=MID (Target Cell, starting point, # of characters)
Since the starting point of ".html" is actually 6 characters after the beginning of what we want to extract, I subtract 6 from the value returned by SEARCH

Hope that helps.