At 08:06 05/12/2007 -0700, Leach, William R wrote:
-----Original Message-----
From: Brian Barker [mailto:[EMAIL PROTECTED]

At 15:24 04/12/2007 -0700, Leach, William R wrote:
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).

[...]
What you need is:
      ="http://www.org.org/page/anotherpage="&A8
or:
      =CONCATENATE("http://www.org.org/page/anotherpage=";A8)

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.

That's easy to get around. You need the HYPERLINK function, which will do what you need on the fly:
     =HYPERLINK("http://www.org.org/page/anotherpage="&A8)

If you want different text from the URL displayed in the cell, use:
     =HYPERLINK("http://www.org.org/page/anotherpage="&A8;"Click Me!")

I trust this helps more.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to