In the realm of Excel functions, there are often scenarios where you need to work with date and time data. This is where the DATEVALUE and TIMEVALUE functions come into play as your trusty allies. These functions enable you to …
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 →
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 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 show how to separate characters from the text where any text appears. Here in the above picture, I am having some text values which contain the word “made”. I will show you how to part out text …
Lesson#110: Separate characters from the text where any word appears 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 →
