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 →
In the world of Excel, when it comes to extracting and manipulating text within cells, the LEFT, RIGHT, and MID functions are your go-to tools. These powerful text manipulation functions allow you to extract specific portions of text from a …
Lesson#235:LEFT, RIGHT, and MID Functions: Text Manipulation Demystified 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 →
Here I will show you a nice trick to split up characters of text in excel. You can see in the above picture I am having a merged cell to put a text in it. I will develop a formula …
Lesson#117: How to split up characters of 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 →
OK. I am back again with some crazy formula. Here in this post, I will show you how to make a formula to separate words from a full name. Here in this above picture, I have a list of names …
Lesson#99: Formula to separate words from a full name Read more →
