Why clog up with a bunch of hyperlinks. Why not just have the typed url in a
list with a double_click event to go there.

Right click sheet tabview codeinsert this. type something like
desiredwebsite.com in a cell and just double click on the cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
ActiveWorkbook.FollowHyperlink _
Address:="http://www." & Target
End Sub


--
Don Guillett
SalesAid Software

"Mareadito Siempre" wrote in
message ...
In excel how do I convert a column that has URL adresses in text form to
hyperlink withouthaving to select each cell place the cursor in it and hit
enter to convert it?
--
Always Learning