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]
