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 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 show you a funny trick to make a dancing chart in excel. For that, you have to follow some steps. 1. Make a range of data names like A, B, C, and D….. 2. Then put values …
Lesson#109: Tricks to make a dancing chart in excel Read more →
Hi friend. Here I will show a method to divert a user to anywhere in the workbook when a link is clicked. For this, some steps are required. Right-click on the cell where the link has to be created. Then …
Lesson#108: How to divert the user to another cell in workbook when clicked 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 →
Okay, friends here I will show you some interesting tricks about Excel. That is how to VLOOKUP pictures in excel. We have learned to look up values from a table but looking up a picture from the table is a …
Do you know which is the easiest method to separate words from the text? It is Text to Columns. Yes, my friend, there is no other easiest way to do it. Now I show you the easiest method to separate …
Lesson#104: The easiest method to separate words from a text Read more →
Here in this post, I will show you how to hyperlink all files and folders in the worksheet within a minute. This can be done very easily. Often we need to make the summary of soft copies and link those …
Lesson#101: Hyperlink all files and folders in the worksheet within a minute 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 →