This is a simple Excel macro that converts a selection of cells into hyperlinks. It's intended for use on large blocks of URLs stored as plain text.

Hyperlinker

Sub Hyperlinker()
Dim rng As Range, workingRng As Range

Set workingRng = Application.Selection
'Code to set boundaries for workingRng, in case user selects entire row, column, or sheet
Set workingRng = Range(Cells(workingRng.Row, workingRng.Column), Cells(lastRowInColumn(workingRng.Column), lastColumnInRow(workingRng.Row)))

For Each rng In workingRng
Application.ActiveSheet.Hyperlinks.Add rng, rng.Value
Next rng

End Sub

Private Function lastRowInColumn(columnRef As Long) As Long
lastRowInColumn = Cells(65536, columnRef).End(xlUp).Row
End Function

Private Function lastColumnInRow(rowRef As Long) As Long
lastColumnInRow = Cells(rowRef, Columns.Count).End(xlToLeft).Column
End Function