is there a way to build a hyperlink -say in cell a2 based on other cells in a worksheet?
thanks for the help
is there a way to build a hyperlink -say in cell a2 based on other cells in a worksheet?
thanks for the help
Re: Build Hyperlink From Cells
Hi zotee98,
I think that function is under Insert -> Hyperlink. Then look for "Place in this document". is that what you are asking?
Regards.
Re: Build Hyperlink From Cells
Out of these 'other cells' in the worksheet, what is the deciding factor of which cell to use to create the hyperlink in A2?
Re: Build Hyperlink From Cells
basically in coulmn b is the file path and in column c is the file name. so i want to combine these and form a hyperlink in column a
Re: Build Hyperlink From Cells
like so?
=HYPERLINK(B1&C1,"Two Cells")
Re: Build Hyperlink From Cells
sweet thanks - worked like a champ - guess i could have checked to see if hyperlink existed in the excel base formulas - thanks again
Don’t have an account yet? Register yourself now and be a part of our community!