Excel VBA Functions: REPLACE

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.

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: