Hyperlink trouble

[ticu]

I have a hyperlnk in cell A1.

I want to place a formula in G1 that says:

= A1

When I do that, I get same text as I have in A1, but it does not behave as a hyperlink.
I want my cell with formula to behave as hyperlink.

I know I can cut/paste from A1 to G1, that gives me hyperlink in G1. However, I want to use a formula. Is this possible to do?

[SteveG]

ticu,

Try this in G1,

=HYPERLINK(A1,"Your link name here")

Just make sure that the hyperlink you have in A1 is written like:

https://www.exceltip.com

If you don't have the "httpw://" prefix as part of your link, this will not work.



HTH

Steve

[ticu]

"SteveG" wrote:

>
> ticu,
>
> Try this in G1,
>
> =HYPERLINK(A1,"Your link name here")
>
> Just make sure that the hyperlink you have in A1 is written like:
>
> https://www.exceltip.com
>
> If you don't have the "httpw://" prefix as part of your link, this will
> not work.
>
>
>
> HTH
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=550316
>
>
Thanks Steve,

This is closest to what I need to achieve.
You are right: if in A1 the cell shows a "friendly name" instead of the
hyperlink itself, it DOES NOT work. But the way you said it, it WORKS.
Thanks again, I may find a way around to figure our the "friendly name"
issue too.

Ticu

[SteveG]

ticu,

You could also have the "https://www." in the HYPERLINK formula so long as the "friendly name" in A1 was the rest of the path, e.g. rather than "Excel Tip" as your friendly name, use "ExcelTip.com".

In G1,

=HYPERLINK("https://www."&A1,"Your link name here")

HTH

Steve