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