Can't create multiple hyperlinks from URL in Excel 14 to open web pages

[kleinermuk]

I can create a hyperlink by double clicking on the field with URL and then Enter button. That method works fine for me, but with hundreds of URL's it will take me forever to create hyperlinks one by one.



I tried to create hyperlinks by highlighting the whole column and clicking Hyperlink button on Toolbar which would make all records in the column blue, but when clicking on each, the Error Message would appear: "Unable to open www.test.com. Can not locate the Internet Server or Proxy Server"



I also tried a different method by creating a new column and inserting formula like =HYPERLINK(J7), which also would create a hyperlink, but when I click on that newly created hyperlink, the Error message would say: "Can not open specified file".



Any idea why first manual method is working and the rest of the methods don't and also on how to fix it, so I won't have to do it manually for a few days?

 

[jardenp]

=HYPERLINK("http://"&J7) works for me with "www.google.com" in J7

 

[kleinermuk]

Something must be wrong with my version of Excel then.

 

[kleinermuk]

it just worked for me after I changed URL from www.test.com to http://www.test.com

 

[jardenp]