Correction to 2nd one, sorry ...
Or, as clickable hyperlinks, in B1 down
=HYPERLINK(A1,"http://www."&MID(A1,SEARCH("/",A1)+2,99))
Try instead in B1:
=HYPERLINK("http://www."&MID(A1,SEARCH("/",A1)+2,99),"http://www."&MID(A1,SEARCH("/",A1)+2,99))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---