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

[mollyc]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[CLR]

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

Vaya con Dios,
Chuck, CABGx3