View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Convert urls to links

You could use some VBA code.
Press Alt+F11 to bring up the VB editor. Next, right-click "ThisWorkbook"
and goto "Insert" and then select "Module".
Paste the following code:

For Each cell In Range("A1:A" & Range("A65536").End(xlUp).Row)
cell.Hyperlinks.Add Anchor:=cell, Address:= _
cell.Value, TextToDisplay:=cell.Value
Next cell




This code assumes that your URLs are in column A.
HTH,
Paul




"Ellen" wrote in message
...
Hello,
I have an Excel document with a column of urls that I'd like to convert to
links. There is nothing in this column except the urls. Is there a way
to
convert them en mass?

Thanks,
Ellen