Count occurrences of given character per cell April 15, 2023 by Tarik An alternative for one cell at a time (formula to be copied down): =len(A2)-len(SUBSTITUTE(A2,"N",""))