Making Hyperlinks Active In Entire Column

[JXD]

Hello,

I am trying to make an entire column of URLs into active hyperlinks in
the worksheet. I don't want to have to do this manually as I have
dozens of links in the column.

Is there a way to automate this process so that the entire column of
URLs is autmatically made into individual, active hyperlinks?

I am an Excel newbie and I am using Excel 2003 on XP.

Thanks for you help.

JXD

 

[Barb Reinhardt]

Use the hyperlink formula

 

[David McRitchie]

That would be creating a second column, assuming
the text contains the complete link address the you can use...

Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#MakeHyperlinks
a version to create Hyperlink Worksheet Formulas also available