View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Natarajan Natarajan is offline
external usenet poster
 
Posts: 5
Default Creating customized hyperlinks to a site

I have a column of values that correspond to a ID.

I need to create a HYPERLINK in this cell that will take me to a specified
URL where the ID changes corresponding to the value in the cell.

8410495 Link
10681746 Link
10681746 Link
1682519 Link
1682519 Link

The generic link is
http://www.ncbi.nlm.nih.gov/sites/en...ubmed_RVDocSum

Note the **** sign in the URL. I want this to be correspondingly replaced
with the ID in each cell.

I am trying to link these IDs to their respective public URLs in PUBMED.

--
Natarajan Ganesan, PhD