Thread: How do I convert column of about 900 web addressesinto hyperlink
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I convert column of about 900 web addressesinto hyperlink
I would use another column and fill it with formulas:

=hyperlink(a1)
or
=hyperlink("http://" & a1)

Depending on what the links look like.

Andy Hendry wrote:

--

Dave Peterson
Reply With QuoteReply With Quote