JKwan
03-04-2005, 04:03 PM
How do I convert a cell into Hyperlink. I've done some processing and build up my web address, the end result looks like below - location in column C ....
http://www.transcanada.com/Alberta/reports/stop_plan/2005_03_03_16_25.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_03_02_16_04.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_03_01_15_55.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_02_28_16_16.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_02_25_15_55.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_02_24_16_10.html
However, they are not hyperlinked to the location, they are more or less "text".
Instead of me clicking on the cell and copy then paste into a Web Browser, how do I convert it to an "actual" hyperlink?
Thanks
http://www.transcanada.com/Alberta/reports/stop_plan/2005_03_03_16_25.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_03_02_16_04.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_03_01_15_55.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_02_28_16_16.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_02_25_15_55.html http://www.transcanada.com/Alberta/reports/stop_plan/2005_02_24_16_10.html
However, they are not hyperlinked to the location, they are more or less "text".
Instead of me clicking on the cell and copy then paste into a Web Browser, how do I convert it to an "actual" hyperlink?
Thanks