ExcelBanter - How to make an entire column of web addresses into hyperlinks?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to make an entire column of web addresses into hyperlinks? (https://www.excelbanter.com/excel-discussion-misc-queries/248181-how-make-entire-column-web-addresses-into-hyperlinks.html)

mollyc

How to make an entire column of web addresses into hyperlinks?

Im trying to figure out how to hyperlink an entire column of websites at the
same time.

Jacob Skaria

How to make an entire column of web addresses into hyperlinks?

In column B try the below formula and copy down
=HYPERLINK(a1)

If this post helps click Yes
---------------
Jacob Skaria

"mollyc" wrote:

Im trying to figure out how to hyperlink an entire column of websites at the
same time.

CLR

How to make an entire column of web addresses into hyperlinks?

="http:\\"&HYPERLINK(A1) and copy down

Vaya con Dios,
Chuck, CABGx3

"mollyc" wrote:

Im trying to figure out how to hyperlink an entire column of websites at the
same time.

All times are GMT +1. The time now is 08:45 PM.