I can open a browser (Chrome or Firefox or Internet Explorer) and enter an IP address in the Address bar, say:
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("220.127.116.11","microsoft") =HYPERLINK("www.18.104.22.168","microsoft") =HYPERLINK("http://www.22.214.171.124","microsoft")
But none of them work.
What am I doing wrong??
Have you tried the following?: