Thread: how do I insert a cell value in a hyperlink formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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 With QuoteReply With Quote