Brian, I sure appreciate your response however I probably didn't tell you enough about what I am trying to do...
Using either of the constructs you suggested the cell contains a properly formed URL. However, it is just text and not a link. If I type the URL into a cell I get a link and the link works. I have 3 similar URLs each of which will take a value after the equals sign. For two of those URLs I essentially want a button (or just text in the cell) that I can click on and have a web browser page open. For the other URL I actually want the web page to load into the spreadsheet. The Hyperlink dialog box makes no sense to me at all UNLESS you have a complete URL that you can just type into the target field. -----Original Message----- From: Brian Barker [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 04, 2007 5:07 PM To: [email protected] Subject: Re: [users] FW: Concatenating a URL and the contents of a cell At 15:24 04/12/2007 -0700, Leach, William R wrote: >I'm starting to feel like a blithering idiot but I can not for the life >of me, figure out how to append the contents of a cell to the end of a >URL. What I have is a URL in the form of >http://www.org.org/page/anotherpage= and need to append a 5 or six >digit number (that is available from the first column of the row). > >I have tried lots of things such as >http://www.org.org/page/anotherpage=A8 > >http://www.org.org/page/anotherpage=$A$8 > >http://www.org.org/page/anotherpage={A8} > >http://www.org.org/page/anotherpage=INDEX(A8) > >None of what I have tried seems to work. Since you are trying to combine a fixed string with the value from another cell, you will need the cell to contain a formula, of course. So you must start your entry with an equals sign. You can easily concatenate your fixed string with the variable value from the other cell using either the "&" operator or the CONCATENATE function. What you need is: ="http://www.org.org/page/anotherpage="&A8 or: =CONCATENATE("http://www.org.org/page/anotherpage=";A8) I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
