Replacing the link

[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!!

 

[Dave Peterson]

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

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

 

[lindakz]

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

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

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?

 

[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.