Extract only certain part of text from a cell

Originally Posted by martindwilson

Formula:

=IF(ISNUMBER(FIND("/",A1)),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),A1)

Hi Martin,

it returns 0 now in all cases..