Hi and welcome to the forum

For future reference, please upload a sample workbook to the forum, it makes it much easier to test with.

Having said that, if the data is in A1, put this in B1 and copy down...
=MID(A1,SEARCH("http",A1,1),SEARCH("add_",A1,1)-SEARCH("http",A1,1)-2)