Count how many times a character appears within a cell using an Excel formula. This same formula can also count the occurrences of a specific word, or any character in a cell.

In this video tutorial, we write an Excel formula to count the number of times an asterisk (*) occurs within a cell. The formula would work for any character.

The formula we use consists of the LEN and SUBSTITUTE functions. Two incredibly useful text functions of Excel.

Find more great free tutorials at;
https://www.computergaga.com

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.