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]