You can convert a range of URLs to hyperlinks in Excel by using the HYPERLINK function. This function will take the text of a URL and convert it into a hyperlink that you can click on. The syntax of the function is as follows:
link_location is the URL that you want to convert, and
friendly_name is the text that you want to display for the hyperlink. If you omit the
friendly_name, then the URL itself will be displayed.
To use this function, first select the cell or range of cells where you want the hyperlinks to appear. Then, enter the following formula into the cell or first cell in the range:
link_location with the actual URL that you want to convert. For example, if you wanted to convert http://www.google.com, you would use the following formula:
If you wanted to display something other than the URL itself as the hyperlink text, then you would use the following formula:
For example, if you wanted to display "Google" as the hyperlink text instead of "http://www.google.com", then you would use the following formula: