Forum Discussion

MicrosoftNewbie121's avatar
MicrosoftNewbie121
Brass Contributor
Feb 02, 2024
Solved

Excel VBA - Delete text from Left

Hello i would like to do this using VBA code : delete in every cell from column "I" the following "Group\" and only leave what comes after  Could you please help me acheving this ? Here is the file...
  • HansVogelaar's avatar
    Feb 02, 2024

    MicrosoftNewbie121 

    Simples:

    Sub DeleteGroup()
        Range("I:I").Replace What:="Group\", Replacement:="", LookAt:=xlPart
    End Sub

Resources