Lesson#252: DATEVALUE and TIMEVALUE Functions: Unleashing the Power of Date and Time Conversion
In the realm of Excel functions, there are often scenarios where you need to work with …
Tag: FIND
Lesson#251: LEFT Function with FIND: Extracting Data Like a Pro
In the world of Excel functions, when it comes to extracting specific data from text, the …
Lesson#251: LEFT Function with FIND: Extracting Data Like a Pro Read more →
Lesson#243: SEARCH and FIND Functions in Excel: Unleashing Text Search Power
In the vast realm of Excel, finding specific text within cells is a common and crucial …
Lesson#243: SEARCH and FIND Functions in Excel: Unleashing Text Search Power Read more →
Lesson#111: Extract parts of text separated by a special character
Here I will show you how to extract parts of text separated by a special character. …
Lesson#111: Extract parts of text separated by a special character Read more →
Lesson#110: Separate characters from the text where any word appears
Here I will show how to separate characters from the text where any text appears. Here …
Lesson#110: Separate characters from the text where any word appears Read more →
Lesson#107: How did I add MS Project features to the Excel project schedule
Here I will discuss a long topic about Excel Gantt chart making. I will show how …
Lesson#107: How did I add MS Project features to the Excel project schedule Read more →
Lesson#99: Formula to separate words from a full name
OK. I am back again with some crazy formula. Here in this post, I will show …
Lesson#99: Formula to separate words from a full name Read more →