In the world of Excel, cleanliness and precision are paramount, especially when dealing with text data. The TRIM function is your trusty companion for eliminating excess spaces, be they leading, trailing, or in-between words. In this expert-level guide, we’ll unravel …
Lesson#242: Excel TRIM Function: Taming Extra Spaces in Text Read more »
In the world of Excel, understanding the LEN function is like having a magnifying glass for your text data. It allows you to count the number of characters in a cell, making it a fundamental tool for tasks like validating …
Lesson#241: Excel LEN Function: Mastering Character Counting Read more »
Hello readers! In this post, we shall learn about the 25 most useful Excel Functions everyone needs to know. Newcomers who start to learn Microsoft Excel gets easily confused with hundreds of excel formulas and functions. So today we shall …
Lesson#155: 25 most useful Excel Functions everyone needs to know Read more »
Now I will show you to make a formula that can count any specific character or characters in a text. This means if I write a “Banana” then this formula can count how many “a” is in that text. So …
Lesson#137: How to count any character in a text in Excel Read more »
Here I will discuss an interesting formula. With this formula, we can calculate the percentage of a text matching another text. In the above picture, I have shown two cells. The first cell has a long text value and the …
Lesson#112: Calculate the match percentage of text which matches another text. Read more »
Here I will show you how to extract parts of text separated by a special character. In the above image, I am having some structure id. Each text has four parts separated by “/”. Each part has a different meaning. …
Lesson#111: Extract parts of text separated by a special character Read more »
Here I will discuss a long topic about Excel Gantt chart making. I will show how I made my excel chart work like the ms project schedule by adding some basic features. Some basic features of the ms project which …
Lesson#107: How did I add MS Project features to the Excel project schedule Read more »
Hello. Now we will learn how to make a master formula to separate words from sentences. For that, I will use functions, TRIM, MID, SUBSTITUTE, REPT, and LEN. 1st step: I will change the text by replacing all the <SPACE> with …
Lesson#100: Making a master formula to separate words from the sentence Read more »
