How do I remove text before and after certain data in a column

[Kdix3013]

I have an excel file that has a column that displays a web source URL. The data looks like this....

http://carter.mydomain.com/page1
http://expert.mydomain.com/page4
http://10629.mydomain.com/sample
http://genius.mydomain.com/form-1
etc

What I need to do is remove everything before and including the (http://) and everything after the first (.) So in the previous examples, I want to be left with the following data in the columns

carter
expert
10629
genius

Thanks in advance for any help with this. Karen

[Ron Coderre]

Try this:

Please Login or Register  to view this content.

Is that something you can work with?

[Kdix3013]

Wow that worked great. Thanks. The only issue that I had was that I just noticed that some of my URLs were actually "https://" instead of just "http://" . Is there a way to add an "and/or" function that would pull out either one, no matter if it was "https://" or "http://"?

Thank you so much.
Karen

[hoyasaxa215]

Only because I want to get notified when Ron responds with a more elegant solution, I'll offer up my attempt below.

Please Login or Register  to view this content.

[Ron Coderre]

Try this:

Please Login or Register  to view this content.

Does that help?