<

How to replace or substitute data in Excel

Posted on
6,039 Points
39 Views
Last Modified:
Community Pick: Many members of our community have endorsed this article.
Experience Level: Intermediate
5:32
Bob Flisser
Bob Flisser has authored many courses and books about Microsoft, Adobe and Apple products, and has been a computer trainer since the 1980s.
Functions for replacing and substituting data in Microsoft Excel.
0
Author:Bob Flisser
0 Comments
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…
The colour setting for coding in the VB editor (VBE) of Microsoft Office is a left-over from a past century. Here is how - with a few steps - to bring new life to the ancient editor.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month