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