I need to dynamically generate hyperlinks based on filenames input into cells
in a worksheet. The problem is that Excel does not recognize the results of
the Concatenate function as text but rather the results of a formula, so it
cannot be used as a hyperlink.
Is there any way to extract the results of a formula a value only. The only
way I can do this now is by copying cells and using Paste Special, values
only. When I do this, Excel will let me use the content as a hyperlink.
Is there a better way??