Excel Letter Counting

An Excel file that teaches how to perform Excel Letter Counting operation.

Excel Template for Letter Counting

The LEN and SUBSTRATE functions are used together. The number of certain letters can be found by formula. Spaces and punctuation are optionally excluded. Multiple letters are counted with the array formula. The results are reported in a table.

Hope it is useful.