I am working with two columns on my spreadsheet. The first column has
numbers. Most of which are about 8 digits long. The second column is a
url. What I am trying to do is add the number in column one to the end
of the url in column 2. The url will be the same for each line. I just
need to add the number in column one to the end of it.
Hope that is enough info. Thanks for any help.


--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: http://www.excelforum.com/member.php...o&userid=27302
View this thread: http://www.excelforum.com/showthread...hreadid=468028

If your stuff is in columns A and B, you can put this in C1 (and drag down)

=B1&A1
or maybe
=b1&text(a1,"00000000")

Or maybe:
=hyperlink(b1&a1)
or
=hyperlink("http://" & b1 & a1)

Depending on what your data is.

johnnstacy wrote:

I am working with two columns on my spreadsheet. The first column has
numbers. Most of which are about 8 digits long. The second column is a
url. What I am trying to do is add the number in column one to the end
of the url in column 2. The url will be the same for each line. I just
need to add the number in column one to the end of it.
Hope that is enough info. Thanks for any help.

--
johnnstacy
------------------------------------------------------------------------
johnnstacy's Profile: http://www.excelforum.com/member.php...o&userid=27302
View this thread: http://www.excelforum.com/showthread...hreadid=468028

--

Dave Peterson