insert URL and data into cells
 

I have a value which corresponds to a database entry that is web-accessible.
I want to know how to combine the base url with the value in the cell, so
that the new entry in the cell is a hyperlink.

e.g. I have the value "133" in a cell.

The base url is
http://www.ncbi.nlm.nih.gov/sites/en...ene&list_uids=

The final url needs to me a combination of the two:
http://www.ncbi.nlm.nih.gov/sites/en...&list_uids=133

I'm not sure if I can do this in search-and-replace, or there is another
method.

insert URL and data into cells
 

A very tiny trick:

If A1 contains:
http://www.cnn.com

and B1 contains:
/world/

then in C1:

=HYPERLINK(A1 & B1)
for a nice "clickable" hyperlink

using =A1 & B1 looks nice, but it is "ice cold"
--
Gary''s Student - gsnu200814


"Brian_M" wrote:

I have a value which corresponds to a database entry that is web-accessible.
I want to know how to combine the base url with the value in the cell, so
that the new entry in the cell is a hyperlink.

e.g. I have the value "133" in a cell.

The base url is
http://www.ncbi.nlm.nih.gov/sites/en...ene&list_uids=

The final url needs to me a combination of the two:
http://www.ncbi.nlm.nih.gov/sites/en...&list_uids=133

I'm not sure if I can do this in search-and-replace, or there is another
method.