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