Custom Hyperlink
 

I would like to have a hyperlink that changes depending on what text is in a
cell.
If cell A1 says 1234, the hyperlink would be:

\\Common\Engineering\SPO-SPP\SPO-1234

If cell A1 says 2468, the hyperlink would be:

\\Common\Engineering\SPO-SPP\SPO-2468

How do I get cell A1 into the hyperlink?
--
Brian H

Custom Hyperlink
 

Use the HYPERLINK function for this, there is ample info in help for this
function


--
Regards,

Peo Sjoblom



"Brian H" wrote in message
...
I would like to have a hyperlink that changes depending on what text is in
a
cell.
If cell A1 says 1234, the hyperlink would be:

\\Common\Engineering\SPO-SPP\SPO-1234

If cell A1 says 2468, the hyperlink would be:

\\Common\Engineering\SPO-SPP\SPO-2468

How do I get cell A1 into the hyperlink?
--
Brian H

Custom Hyperlink
 

Thanks.
I wasn't having luck with that but finally figured it out. The part I was
missing was
............"&A1
=HYPERLINK("\\Common\Engineering\SPO-SPP\SPO-"&A1,A1)
--
Brian H


"Peo Sjoblom" wrote:

Use the HYPERLINK function for this, there is ample info in help for this
function


--
Regards,

Peo Sjoblom



"Brian H" wrote in message
...
I would like to have a hyperlink that changes depending on what text is in
a
cell.
If cell A1 says 1234, the hyperlink would be:

\\Common\Engineering\SPO-SPP\SPO-1234

If cell A1 says 2468, the hyperlink would be:

\\Common\Engineering\SPO-SPP\SPO-2468

How do I get cell A1 into the hyperlink?
--
Brian H