Excel VBA Functions: REPLACE

See the full list of VBA functions here: excelmacroclass.blogspot.com/...
Welcome to Excel VBA Functions Series. In this video we see the string function REPLACE., which is used to find and replace a sub-string within a string. The introduction explains the difference between the Replace VBA Function, the Replace Excel built-in worksheet function (which in VBA is a method of the WorksheetFunction object), and the Replace functionality in Excel, which in VBA is a method of the Range object. The Replace VBA functions accepts various parameters: expression, find, replace, start, count, and compare mode. The VBA Replace function is very useful to work with text in Excel, it allows to find and replace characters or text. The video shows various examples where we can use REPLACE in Excel.
Find more content and numerous macro examples and other Excel VBA learning materials in the Excel Macro Class blog under the direct link: excelmacroclass.blogspot.com/
And yet, if you want more, you can find various Excel templates, dashboards, and applications of different nature in the other blogs of the Excel Macro Mania saga:
Excel Macro Fun (excelmacrofun.blogspot.com/)
Excel Macro Business (excelmacrobusiness.blogspot.com/)
Excel Macro Sports (excelmacrosports.blogspot.com/)