I have a sheet like this:
https://dl.dropboxusercontent.com/u/...inkEntry-1.jpg
I've pasted in the entire column A of over a hundred filenames.

In col B I want to automate the entry of their hyperlinks.

They are all from a single Explorer folder whose path is in A1. The
text is just the filename (preferably without the extension, but
that's unimportant.)

So the result would look like this:
https://dl.dropboxusercontent.com/u/...inkEntry-2.jpg
I've struggled with automating this for an hour or so, but in vain,
and would much appreciate some help please.

--
Terry, East Grinstead, UK