Replacing the link

L

lindakz

Hi. I have made a spreadsheet that shows a name of a person and next
to it the website link to thier introductory post for my group.
Instead of having the whole link visible, how would I change it to
just show the word "LINK" but clicking on it would take you to the
link?

Thanks!!
 
L

lindakz

I like to use the =hyperlink() worksheet formula:

=hyperlink("http://www.microsoft.com","Link")
Click to expand...


Hi Dave. Brilliant!! Thanks, that worked. Now...If I already have 50
of these in a column, is there a way to permanently do this to all of
the cells at one time and in the column and for the future?
 
D

Dave Peterson

Do you have the links in a different cell on the same row?

=hyperlink(a2,"link")
or
=hyperlink("http://"&a2,"link")
or whatever you need.

You could hide the column with the real link if you wanted.
 
Top