Try this in B1:
=IF(ISNUMBER(SEARCH("www",A1)),HYPERLINK(A1,A1),HY PERLINK("http://www."&MID(A1,SEARCH("/",A1)+2,99),"http://www."&MID(A1,SEARCH("/",A1)+2,99)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dileep Chandran" wrote in message
oups.com...
Max,
This formula is working fine. Thanks !
But if the cell contains an address in the desired format (ie. starting
with "http://www."), the formula should not change it. Is there a way
to do it?
Is my question clear?
Dileep