Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 07, 07:46 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 1
Default 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   Report Post  
Old December 18th 07, 09:47 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
what formula will get the url from a cell with a hyperlink? polytx Excel Worksheet Functions 7 May 29th 08 06:54 AM
formula to choose a hyperlink from a cell Luong Vinh Tu Excel Worksheet Functions 1 September 25th 06 04:13 AM
How do I insert the value of a cell into a Hyperlink CW2 James Reed Excel Discussion (Misc queries) 1 March 4th 06 05:25 PM
insert hyperlink Gary''s Student Excel Discussion (Misc queries) 0 November 19th 05 03:13 PM
Using a formula in a Hyperlink Cell reference sslabbe Excel Discussion (Misc queries) 4 December 10th 04 01:30 AM


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017