Remove and Replace All Characters in Microsoft Excel using VBA
The following FindandReplace() funciton allows you to replace or remove specific text and characters you want in Microsoft Excel. Just copy...
https://msexcel-tutorials.blogspot.com/2014/08/remove-and-replace-all-characters-in_24.html
The following FindandReplace() funciton allows you to replace or remove specific text and characters you want in Microsoft Excel. Just copy the code below on your VBA code class or module.
Put this in your Sub or Function.
To Replace several text with new text.
To remove several text just leave the second argument blank.
1 2 3 4 5 6 | Sub FindandReplace(FindWhat as String, ReplaceWith as String) Cells.Replace What:=FindWhat, Replacement:=ReplaceWith, LookAt:=xlPart, SearchOrder:= _ xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=FalseEnd Subz |
Put this in your Sub or Function.
To Replace several text with new text.
1 | >FindandReplace "OldText", "NewText" |
To remove several text just leave the second argument blank.
1 | FindandReplace "OldText", "" |
