Assuming your url's are in column A:
In a seperate column, use this formula
=HYPERLINK(A2,A2)
Copy down as needed.

For viewability, I'd then hide the column contain the dead url's.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Judy1997" wrote:

I have a column of 3,000 urls in format http://www.... None of these are
actually enabled . I need to be able to click on them and go right to the
website. I also need the actual website address to still show, AND be
clickable. Is there a way to do this without manually going in to the
"insert hyperlink" box and doing all 3000 one at a time?! I have excel 2003.