Learn more about excel - https://exceltutorial.net

============================================================ Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Other Playlists:-

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz

Excel Formulas: https://www.youtube.com/playlist?list=PLhvn6aQRdimWPxkOxbRjkFCGcEp6-kMtJ

Excel Errors: https://www.youtube.com/playlist?list=PLhvn6aQRdimVXfu4qRN88TS7L1HgZ_rXI

Excel Power Query Masterclass:- https://youtube.com/playlist?list=PLhvn6aQRdimW7duwTzNlI5MJrwRZW7ki1

Printing In Excel:- https://youtube.com/playlist?list=PLhvn6aQRdimUXBeW973mOHAVKfT2-g3MO

============================================================

Practice Sheets: https://docs.google.com/spreadsheets/d/1sM7wcnSdKfwj27SOAO8CPIx9q_oBVXzwbsWdhhZowF8/edit?usp=sharing

============================================================ In this video, We will discuss how to count specific word occurs in a cell as we have done before but the case was to count in different cells. Heres the limitation of count functions. You can not count a specific word occurs in a cell, therefore we will use LEN and SUBSTITUTE Function to resolve the same. To continue learning, browse the content below;

Table Of Content: 00:00 Introduction 01:08 Adding Helper Value 02:22 Adding Length of the cell using LEN Function 03:10 Substituting Value with Blank Value using LEN & SUBSTITUTE Function 04:16 Calculating the number of John in Specific Cell 04:57 Complete formula to Count Specific Word Occurs in a Cell 07:32 Conclusion

Hope you get to know what we are trying to say, if you want to learn more please do subscribe to our channel and do buy our Excel Masterclass Course.

Disclaimer:- The Character/person in the cover picture is for representation purposes only. ... https://www.youtube.com/watch?v=a6vizywaysQ