Convert urls to links
 

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

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

Convert urls to links
 

Thanks for your help, Paul. After doing a little checking out, I preceded
your code with "Sub url()" and ended it with "End sub". The code worked
beautifully!!
Ellen

"PCLIVE" wrote:

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