if Left(Cells(i, 1), 4)="7" then
Cells(i, 14).Value = "direct"
Sub Test()
Dim var As String
For i = 1 To 2
var = Mid( Cells(i, 1), 4, 1)
If var = "7" Then
Cells(i, 14).Value = "direct"
End if
Next i
End sub