One guess ... with source entries in A1 down,
perhaps in B1, copied down:
="http://www."&MID(A1,SEARCH("/",A1)+2,99)
(above returns as text)

Or, as clickable hyperlinks, in B1 down
=HYPERLINK(A1,"http://www."&MID(A1,SEARCH("/",A1)+2,99))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dileep Chandran" wrote in message
ps.com...
Hi,

I am just trying to format a range of cells. What I need is, If we
enter a web address say, http://yahoo.com, the cell should
automatically convert it as http://www.yahoo.com.

Is it possible?. Any help is greatly appreciated.

Thanks

-Dileep Chandran