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 for testing
Thank you forward,
Simples:
Sub DeleteGroup() Range("I:I").Replace What:="Group\", Replacement:="", LookAt:=xlPart End Sub
2 Replies
Simples:
Sub DeleteGroup() Range("I:I").Replace What:="Group\", Replacement:="", LookAt:=xlPart End Sub- MicrosoftNewbie121Brass ContributorHello it's working like a charm 🙂 thank you so much Hans