How to use the Excel’s Hyperlink function

Sometimes, I open a text file which has URLs in Microsoft Excel. and manipulate the data.

That time, One of the useful function is HYPERLINK.

1. Try it…

=HYPERLINK(”telnet://”&A1&””)

<==A1 cell has a URL or IP address like this….

Click the address. and You’ll see a dos window or web browser which tries to connecting the [...]