How-To Tutorials – Iran VBA

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…

The Complete Guide to Installing Windows 10 on an Ubuntu Virtual Machine with Shared Clipboard and Folder

Post author:ایران وی‌بی‌ای
Post published:August 28, 2025
Post category:Linux and Command Line Tools
Post comments:0 Comments

If you want to install Windows 10 on Ubuntu using Virtual Machine Manager (virt-manager) and have Copy/Paste and shared folder access, follow this step-by-step guide. Step 1: Installing the Virtual…

Step-by-step guide showing how to consolidate multiple Excel worksheets into a single sheet using VBA macros for automation.

How to Merge Multiple Excel Sheets into One Using VBA

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

In this comprehensive guide, you’ll learn how to automatically merge data from multiple Excel sheets into a single master sheet using VBA. Introduction Sample Sales Reports and the Goal of…

Fixing File and Folder Permission Errors in Apache and Nginx on Linux (Ubuntu)

Post author:ایران وی‌بی‌ای
Post published:July 18, 2025
Post category:Working with Developer Tools
Post comments:0 Comments

When setting up or developing a website on a Linux server, you may encounter common access-related issues like 403 Forbidden, Permission denied, or similar errors from Apache or Nginx. These…