Only required domain name in excel sheet

[laurajames]

How to remove all extra thing except domain name in excel sheet

Like this
holapaints.com
root domain


Root domain is written on thousand of emails. How to remove it at once in excel sheet .

Plus , in this case , slash and commas are on thousand of emails. How to remove it at once in excel sheet .

\"holapaints.com


I want your help!

 

[nemmi69]

Try

=SUBSTITUTE(SUBSTITUTE(MID(A2,SEARCH("//",A2)+2,LEN(A2)),"www.",""),"/","")

 

[nemmi69]

and to remove the .com

=LEFT(SUBSTITUTE(SUBSTITUTE(MID(A2,SEARCH("//",A2)+2,LEN(A2)),"www.",""),"/",""),LEN(SUBSTITUTE(SUBSTITUTE(MID(A2,SEARCH("//",A2)+2,LEN(A2)),"www.",""),"/",""))-(FIND(".",SUBSTITUTE(SUBSTITUTE(MID(A2,SEARCH("//",A2)+2,LEN(A2)),"www.",""),"/",""))-1))