Prev: Weighted averaging of dates
Next: newsgroups
From: lindakz on 6 Jul 2008 12:17
I have a column of links to various web pages. How would I change the
whole column to show the words 'Click here" instead of showing the
link for each cell? Is there a formula?
Thanks in advance!!
From: Dave Peterson on 6 Jul 2008 12:34
Depending on what that other cell contained, I'd use a formula in an adjacent
cell that looked like this:

=hyperlink(A1,"Click here")
or
=hyperlink("http://"&A1,"Click here")

But I could only use this if the link actually appeared in the cell.

lindakz(a)earthlink.net wrote:
>
> I have a column of links to various web pages. How would I change the
> whole column to show the words 'Click here" instead of showing the
> link for each cell? Is there a formula?
> Thanks in advance!!

--

Dave Peterson
 | 
Pages: 1
Prev: Weighted averaging of dates
Next: newsgroups