Forum Discussion
MicrosoftNewbie121
Feb 02, 2024Brass Contributor
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...
- Feb 02, 2024
Simples:
Sub DeleteGroup() Range("I:I").Replace What:="Group\", Replacement:="", LookAt:=xlPart End Sub
HansVogelaar
Feb 02, 2024MVP
Simples:
Sub DeleteGroup()
Range("I:I").Replace What:="Group\", Replacement:="", LookAt:=xlPart
End Sub- MicrosoftNewbie121Feb 02, 2024Brass ContributorHello it's working like a charm 🙂 thank you so much Hans