Hi guys, need your help!

I have a list of over 500 000 webpages. Some of them are listed with http:// or https://, some have www. and some don't, some have .com/somethinghere and some don't.

Webpages are different (from different domains, some are subdomains, etc).

Thing is that I need a formula that would remove everything except the actual domain name. For example out of this:

http://www.examplesite.com/whateverhere or;
http://examplesite.site.com/verylong...ndomcharacters or
examplesite.com/whatever

I need to get this

examplesite.com - no https, no forward slash, no www - plain domain name.

I have found a temporary solution using text-to-cell with "/" as separator together with SUBSTIUDE, but going forward I will have much more such lists and I need to create template.

Thank you!