Excel - Iran VBA

Step-by-step tutorial for activating the Developer tab in Excel and using VBA and macros

Developer Tab in Excel | How to Enable the Developer Tab in Excel

Post author:ایران وی‌بی‌ای
Post published:September 21, 2025
Post category:VBA Programming and Excel Macros
Post comments:0 Comments

The Developer tab is the starting point for macro programming in Excel. This tab is not enabled by default in Excel. [1] Step-by-step tutorial on activating the Developer tab in…

Learn how to count the occurrences of any character in a text string by cleverly combining the LEN and SUBSTITUTE functions in Excel. This is an essential and practical trick for text data analysis.

Count the Number of a Specific Character in Excel | Using SUBSTITUTE and LEN Functions Together

Post author:ایران وی‌بی‌ای
Post published:September 5, 2025
Post category:Excel Formulas and Functions
Post comments:0 Comments

There is no dedicated function in Excel to count the number of repetitions of a specific character in a cell's text.In this step-by-step tutorial, we will learn how to perform…