How to

How to calculate the number of times an alphabet (e.g. "a") occur in a word contained within a cell If the cell A1 contains the word/phrase (e.g. "lose weight") and you want to find how many times the alphabet "e" appears in word/phrase, you can make use of the formulas LEN and SUBSTITUE to find out.


New! Comments

Have your say about what you just read! Leave me a comment in the box below.

Share this page:

What’s this?

Enjoy this page? Please pay it forward. Here's how...

Copyright © advanced-excel.com 2007 - 2019. All Rights Reserved. Privacy Policy

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.

advanced-excel.com is in no way associated with Microsoft