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 functions, when it comes to extracting specific data from text, the LEFT and FIND functions are a dynamic duo. By combining these two powerful functions, you can precisely pinpoint and extract data from your text …
Lesson#251: LEFT Function with FIND: Extracting Data Like a Pro Read more »
In the vast realm of Excel, finding specific text within cells is a common and crucial task. This is where the SEARCH and FIND functions step in as your trusty text detectives, helping you locate and manipulate text data with …
Lesson#243: SEARCH and FIND Functions in Excel: Unleashing Text Search Power 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 »
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 »
