Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Concatenate Formula
Hi!
I am trying to insert a concatenate formula for a https site i.e =concatenate("https://websiteaddress,"A1",moreurldetail, "B1") I think im looking for something like ActiveCell.FormulaR1C1 = " =concatenate("https://websiteaddress",R[1]C[1], "moreurldetail,"R[1]C[2]")" Thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Concatenate Formula
What exactly are you trying to accomplish with the formula? I ask, because as a beginner I have often thought I knew what I needed and in the end it turned out I was completely wrong. Whereas, I don't have an answer, maybe if one of the others that reall *knows* what they are doing knows what your are trying to accomplis they might be able to steer you better. Just a thought. : -- Amber_D_Law ----------------------------------------------------------------------- Amber_D_Laws's Profile: http://www.excelforum.com/member.php...fo&userid=3001 View this thread: http://www.excelforum.com/showthread.php?threadid=49706 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Concatenate Formula
Amber,
Im trying to open a single https page by hyperlinking in using the concatenate funtion Amber_D_Laws wrote: What exactly are you trying to accomplish with the formula? I ask, because as a beginner I have often thought I knew what I needed and in the end it turned out I was completely wrong. Whereas, I don't have an answer, maybe if one of the others that reall *knows* what they are doing knows what your are trying to accomplis they might be able to steer you better. Just a thought. : -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Concatenate Formula
Yeah, but...
Do you really want to see "B1" and "A1" in the results or do you want to see the stuff in cells A1 and B1? =concatenate("https://websiteaddress,"A1",moreurldetail, "B1") =hyperlink("https://websiteaddress/" & $a$1 & "moreurldetail" & $b$1) I'm guessing that you want what's in the cells: ActiveCell.Formula _ = "=hyperlink(""https://websiteaddress/"" & $a$1 & ""moreurldetail"" & $b$1)" (I like to use the & operator instead of the =concatenate() function. I find it easier to read.) "DARREN FONG via OfficeKB.com" wrote: Amber, Im trying to open a single https page by hyperlinking in using the concatenate funtion Amber_D_Laws wrote: What exactly are you trying to accomplish with the formula? I ask, because as a beginner I have often thought I knew what I needed and in the end it turned out I was completely wrong. Whereas, I don't have an answer, maybe if one of the others that reall *knows* what they are doing knows what your are trying to accomplis they might be able to steer you better. Just a thought. : -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a hard return in a =CONCATENATE formula in excel | Excel Worksheet Functions | |||
how insert the return key in formulas for concatenate of text? | Excel Discussion (Misc queries) | |||
How to CONCATENATE 50 fields in Excel table into SQL Insert State | Excel Discussion (Misc queries) | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
How do I insert a line break when using the CONCATENATE function? | Excel Worksheet Functions |