how to hyperlink a column of fileserver addresses?
With the address in A1, enter in B1:
=HYPERLINK(A1) and copy down
--
Gary''s Student - gsnu200812
"stumped-in-excel" wrote:
created index spreadsheet in excel03 - Need to hyperlink to respective
documents. I have column of the document addresses included so I know where
they need to be linked to.
|