Formula to remove part of URL

[KMockingb]

I have a sheet with several thousands of URLs that look like this:

http://www.example.com/2349823948/http://www.example2.com/some-url.html
http://www.example.com/2300003948/http://www.example2.com/some-url2.html

Is there a good formula/process for creating a column that removes everything before the 2nd http?

So that they look like this?

http://www.example2.com/some-url.html
http://www.example2.com/some-url2.html

Thanks!

 

[Rick Rothstein]

I have a sheet with several thousands of URLs that look like this:

http://www.example.com/2349823948/http://www.example2.com/some-url.html
http://www.example.com/2300003948/http://www.example2.com/some-url2.html

Is there a good formula/process for creating a column that removes everything before the 2nd http?

Assuming the first "http" is always at the beginning of the text, give this formula a try...

=MID(A1,SEARCH("http://",A1,2),LEN(A1))

 

[KMockingb]

It worked! Thank you!