I have a spread sheet with 700 file names and I need to link all the file
names to the files, is there a way hyperlink all of them at once instead of
doing them one at a time? I need to put all the files which some are in sub
directories on a cd and have the hyperlinks open the files on the cd from the
spreadsheet that will be in the root of the disk.

The file names start in B:2 and I would like to either link to the files in
the B column or in a helper column such as C:2

Any help would be greatly appreciated

Thanks!