Formula:
=LEFT(SUBSTITUTE(SUBSTITUTE(IF(ISNUMBER(SEARCH("//",A1)),MID(A1,SEARCH("//",A1)+2,255),A1),"www.",""),"ww.",""),FIND("/",SUBSTITUTE(SUBSTITUTE(IF(ISNUMBER(SEARCH("//",A1)),MID(A1,SEARCH("//",A1)+2,255),A1),"www.",""),"ww.",""))-1)
Formula:
=LEFT(SUBSTITUTE(SUBSTITUTE(IF(ISNUMBER(SEARCH("//",A1)),MID(A1,SEARCH("//",A1)+2,255),A1),"www.",""),"ww.",""),FIND("/",SUBSTITUTE(SUBSTITUTE(IF(ISNUMBER(SEARCH("//",A1)),MID(A1,SEARCH("//",A1)+2,255),A1),"www.",""),"ww.",""))-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks