How do I convert column of about 900 web addressesinto hyperlink
 

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

How do I convert column of about 900 web addressesinto hyperl
 

Hi Dave,

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

Many thanks!

Whyvon

"Dave Peterson" wrote:

I would use another column and fill it with formulas:

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

Depending on what the links look like.

How do I convert column of about 900 web addressesinto hyperl
 

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.



Why Von wrote:

Hi Dave,

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

Many thanks!

Whyvon

"Dave Peterson" wrote:

I would use another column and fill it with formulas:

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

Depending on what the links look like.

--

Dave Peterson