Insert Hyperlink to an IP Address

Posted on

Problem :

I can open a browser (Chrome or Firefox or Internet Explorer) and enter an IP address in the Address bar, say:

134.170.185.46

and the browser will open the website (Microsoft.com) directly – bypassing any need to resolve the DNS.

I am trying to insert a hyperlink in an Excel worksheet cell to do the same thing. I have tried the following:

=HYPERLINK("134.170.185.46","microsoft")
=HYPERLINK("www.134.170.185.46","microsoft")
=HYPERLINK("http://www.134.170.185.46","microsoft")

But none of them work.

enter image description here

What am I doing wrong??

Solution :

Have you tried the following?:

=HYPERLINK("http://134.170.185.46","microsoft")

Leave a Reply

Your email address will not be published. Required fields are marked *