How do I convert column of about 900 web addressesinto hyperlink

[Dave Peterson]

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:

 

[Why Von]

Hi Dave,

Can you elaborate on this? I'm a novice user and am having the same issue.

Many thanks!

Whyvon

 

[Dave Peterson]

If you have
www.microsoft.com
in A1, then put this in B1
=hyperlink("http://" & a1)

You'll end up with a hyperlink in B1 that points at the site in A1.