Automatically applying hyperlinks from one cell to another

Solution 1:

If you want to use formulas and links do not follow a simple pattern then you need to copy your titles into another column (or sheet) and refer to them in your hyperlink formula.

HYPERLINK("link","copied_title")

Look below;

For the other desired option, you still have to use VBA but maybe only a user-defined option would be sufficient as described in one of the answers in this thread: Extracting URLs from Hyperlinks

VBA Solution

If you are interested in VBA, something like this would help:

Sub hyperlink_title()
    Dim i As Integer
    Dim wsh as Worksheet
    Set wsh = ThisWorkbook.ActiveSheet

    i = 4
    With wsh
    While .Cells(i, 2) <> ""

        ActiveSheet.Hyperlinks.Add Anchor:=.Cells(i, 2), Address:=.Cells(i, 3).Value, _
        TextToDisplay:=.Cells(i, "B").Value2

        i = i + 1

    Wend

End Sub