Thread: [Solved] many delet and replace
View Single Post
 
Old 06-14-2017, 05:00 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Experiment with this.
Code:
Sub DeleteOrReplaceCharacters()

With Range("A2:A10")
    .Replace "a", "", xlPart
    .Replace "&", "", xlPart
    .Replace "{", "(", xlPart
    .Replace "d", "3", xlPart
End With

End Sub
Reply With Quote