When you paste or import text that looks like a hyperlink into a cell, the hyperlink does not actually work but remains as a text entry. If you type the same text into a cell by using the keyboard, Microsoft Excel interprets the entry as an active hyperlink.

The cause lies here:

Microsoft Excel does not interpret these text values as hyperlinks unless they are typed from the keyboard.

To convert cells that contain valid hyperlink text in Excel to active hyperlinks, use one of the following methods.

Method 1: Edit the Hyperlink by Using the Keyboard

1. Select a cell that contains a hyperlink that appears as text.
2. Press F2 and then press ENTER.
3. Repeat steps 1 and 2 for each cell, as needed.

Method 2: Use a Macro

Sub HyperAdd()
‘
‘ Converts each text hyperlink selected into a working hyperlink
‘
For Each xCell In Selection
ActiveSheet.Hyperlinks.Add Anchor:=xCell, Address:=xCell.Formula
Next xCell
‘
‘
End Sub

Now save that macro and run it on your cells.

Method 3: Use Hyperlink function

You can use in a new cell the HYPERLINK function which will convert text to link and apply that to all cells. Only downside is that a new column will be used.