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.