I have to replace the variant at end only. can we do that if so please can anyone help on this?

code:

```
Worksheets("Part_Number").Columns("F").Replace What:="-G", Replacement:=" ", SearchOrder:=xlByColumns, MatchCase:=True

```

Input:  

```
WA-2001-G 
WA-GSK024

```

Expected Output:  

```
WA-2001 
WA-GSK024

```