SOLVED

Excel VBA - Delete text from Left

Brass Contributor

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,

2 Replies
best response confirmed by MicrosoftNewbie121 (Brass Contributor)
Solution

@MicrosoftNewbie121 

Simples:

Sub DeleteGroup()
    Range("I:I").Replace What:="Group\", Replacement:="", LookAt:=xlPart
End Sub
Hello it's working like a charm :) thank you so much Hans
1 best response

Accepted Solutions
best response confirmed by MicrosoftNewbie121 (Brass Contributor)
Solution

@MicrosoftNewbie121 

Simples:

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

View solution in original post