Hui
Thanks for the reply
with the above formulae, when clicked the error msg is "cannot open the specified file".
However my requirement is that in A2 I have the company name, (or business description)
by cliking on A2 I like to create a hyperlink to the website, the website address (...
I have an excel sheet with web addresses typed in Col D rows after rows running to several hundred lines with addresses in text format.( eg; www.cookfood.net)
I want to insert the hyperlink in Col A with the text address from col D for each line.
manually i have done for few as ( eg: line 2)...