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]

Reply via email to