software

Hi! I'm hoping this will be very simple. I'm working on a database with
hundreds of contacts. Column A has the contact names, and Column B has their
URLs. I need the cells with the contact names to be linked to their
respective websites. Doing it the old-fashioned way, I could either left-
click the contact names and insert hyperlinks by copying and pasting the URLs
one at a time. Or I could left-click the URLs and edit hyperlinks, copying
and pasting the text to display one at a time. Obviously, I'd much rather
find a quicker way. I tried creating a macro, but it would only paste data
from the first cell onto all the other ones.

It seems that the HYPERLINK function would be perfect. I go to Column C,
apply the function, and it asks me to choose the hyperlink cell and the
quot;friendly textquot; cell. So I end up typing =HYPERLINK(A1,B1), and the result
in Column C appears to be exactly what I want. It has the contact name, and
when I hover over it, it indicates that it will link me to the URL. However,
that doesn't happen when I actually click on it. Instead, it gives me an
error of quot;cannot open the specified file,quot; and the formula bar shows the
formula instead of the intended content. Sorry if this is a FAQ or in the
wrong board, but I'm new to asking for Excel help. Thanks in advance!

Bob

Figured it out after much more Googling! My URL cells did not contain the
quot;quot; in front of the web addresses. Once I added it, the newly created
links worked! Thanks!

Bob

otspbob wrote:
gt;Hi! I'm hoping this will be very simple. I'm working on a database with
gt;hundreds of contacts. Column A has the contact names, and Column B has their
gt;URLs. I need the cells with the contact names to be linked to their
gt;respective websites. Doing it the old-fashioned way, I could either left-
gt;click the contact names and insert hyperlinks by copying and pasting the URLs
gt;one at a time. Or I could left-click the URLs and edit hyperlinks, copying
gt;and pasting the text to display one at a time. Obviously, I'd much rather
gt;find a quicker way. I tried creating a macro, but it would only paste data
gt;from the first cell onto all the other ones.
gt;
gt;It seems that the HYPERLINK function would be perfect. I go to Column C,
gt;apply the function, and it asks me to choose the hyperlink cell and the
gt;quot;friendly textquot; cell. So I end up typing =HYPERLINK(A1,B1), and the result
gt;in Column C appears to be exactly what I want. It has the contact name, and
gt;when I hover over it, it indicates that it will link me to the URL. However,
gt;that doesn't happen when I actually click on it. Instead, it gives me an
gt;error of quot;cannot open the specified file,quot; and the formula bar shows the
gt;formula instead of the intended content. Sorry if this is a FAQ or in the
gt;wrong board, but I'm new to asking for Excel help. Thanks in advance!
gt;
gt;Bob