| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I insert a cell value in a hyperlink formula
I need to insert a value from another cell in the same spreadsheet say B2 to
replace nnnnnn in the following hyperlink and have tried &B2, "B2","&B2&" !B2, =B2, nothing seems to work. Any ideas? Thanks in advance. http://domweb21.bank.net/apps/ecms/C...&Annnnnn&ANorm |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I insert a cell value in a hyperlink formula
Maybe...
=HYPERLINK("http://domweb21.bank.net/apps/ecms/CCAApp.nsf/wwwApprLkup?" &"ReadForm&Multi=No&NextStep=Close&ATxCrNum&A"&B2& "&A"&B2&"&Anorm","click me") If that value in B2 has to be formatted, you may want something like: =HYPERLINK("http://domweb21.bank.net/apps/ecms/CCAApp.nsf/wwwApprLkup?" &"ReadForm&Multi=No&NextStep=Close&ATxCrNum&A"&tex t(B2,"0000") &"&A"&text(B2,"0000")&"&Anorm","click me") maijik wrote: I need to insert a value from another cell in the same spreadsheet say B2 to replace nnnnnn in the following hyperlink and have tried &B2, "B2","&B2&" !B2, =B2, nothing seems to work. Any ideas? Thanks in advance. http://domweb21.bank.net/apps/ecms/C...&Annnnnn&ANorm -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what formula will get the url from a cell with a hyperlink? | Excel Worksheet Functions | |||
| formula to choose a hyperlink from a cell | Excel Worksheet Functions | |||
| How do I insert the value of a cell into a Hyperlink | Excel Discussion (Misc queries) | |||
| insert hyperlink | Excel Discussion (Misc queries) | |||
| Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
Linear Mode
