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 »

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 »