Help converting formula to VBA

[Frank3923]

I need assistance in converting a formula over to vba, I have inserted the formula, as well as my attempt to change it. Being that I am not a programmer, I would appreciate any assistance in showing me, the proper way to list the formula into the mace

formula needed to be inserted

=LEFT(G8,FIND("(",G8)-1)

This is my attempt to create it, in VBA

Range("E" & i + 1).Formula = "=Left(Range(G" & i + 1 & Find(" ""("", Range("G" & i)-1 & ")"

 

[Frank3923]

Here is my code,
'=LEFT(G8,FIND("(",G8)-1)


Sub Get_TValue2()
Dim LR As Long: LR = Range("G" & Rows.Count).End(xlUp).Row


For i = 1 To LR
If Trim(Range("G" & i).Value) = "Final" Then
Range("E" & i + 1).Formula = Range("E" & i).Formula = "=LEFT(G" & i & ",FIND(""("",G" & i & ")-1)"
End If
Next i

End Sub

 

[jmthompson]

How can G = Final and have a (

 

[Frank3923]

It is a imported table. In Column "G", the word "Final" appears numerious times. Each time there is an instance of the word "Final",

there are 2 rows immediately below that contain a text string, which contains the ( , and I needed everything to the left of the ( .

EXAMPLE

Final
Baltimore (0-5-5-9-3)
Philadelphia (1-0-0-6-8)