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

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

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



wrote:

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

On Jan 31, 9:00*am, Dave Peterson wrote:
I like to use the =hyperlink() worksheet formula:

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

wrote:

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


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?

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.

wrote:

On Jan 31, 9:00 am, Dave Peterson wrote:
I like to use the =hyperlink() worksheet formula:

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

wrote:

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

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