Convert list of URLs to Hyperlinks
 

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the column a
link in the sheet?

Convert list of URLs to Hyperlinks
 

In B1:

=HYPERLINK(A1,A1) and copy down
--
Gary''s Student - gsnu200829


"jabe813" wrote:

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the column a
link in the sheet?

Convert list of URLs to Hyperlinks
 

Novice at this...

The URL list is in column B.

When I put
=HYPERLINK(A1,A1)

in B1, it changes the the URL that was displayed to a 0

"Gary''s Student" wrote:

In B1:

=HYPERLINK(A1,A1) and copy down
--
Gary''s Student - gsnu200829


"jabe813" wrote:

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the column a
link in the sheet?

Convert list of URLs to Hyperlinks
 

If your hyperlink text is in column B, change the A1 to B1 in the formula.
--
David Biddulph

"jabe813" wrote in message
...
Novice at this...

The URL list is in column B.

When I put
=HYPERLINK(A1,A1)

in B1, it changes the the URL that was displayed to a 0

"Gary''s Student" wrote:

In B1:

=HYPERLINK(A1,A1) and copy down
--
Gary''s Student - gsnu200829


"jabe813" wrote:

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the
column a
link in the sheet?

Convert list of URLs to Hyperlinks
 

Thank you. I tried that as well.

Instead of displaying a 0 it displays "Address"
Links to the right place but, I need to display the URL

I am supposed to be putting this in the formula bar, correct?

"David Biddulph" wrote:

If your hyperlink text is in column B, change the A1 to B1 in the formula.
--
David Biddulph

"jabe813" wrote in message
...
Novice at this...

The URL list is in column B.

When I put
=HYPERLINK(A1,A1)

in B1, it changes the the URL that was displayed to a 0

"Gary''s Student" wrote:

In B1:

=HYPERLINK(A1,A1) and copy down
--
Gary''s Student - gsnu200829


"jabe813" wrote:

I have sheet that contains a column of URLs that are NOT linked.

Is there a way I can automate the process and make every URL in the
column a
link in the sheet?