spot_img

Counting occurrences of a character in a spreadsheet

In this Excel tutorial you will teach yourself how to count occurrences of a character in a spreadsheet. Let’s count how many of f character do you have in a A column. To do that just use below formula:=SUM(LEN(A:A)-LEN(SUBSTITUTE(A:A;”f”;””))) This is an array formula so remember to press CTRL + SHIFT + ENTER combination.

Counting character occurences

Counting occurrences of a character in a spreadsheet may be useful for spreadsheets with unique text. Also you may be interested in counting character which is related to your company/project and used as a your internal code.


Template

You can download the Template here – Download
Further reading: 
Basic concepts 
Getting started with Excel
Cell References
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell

RELATED ARTICLESMORE FROM AUTHOR