Forum Discussion
DutchArjo
Oct 29, 2022Copper Contributor
count number of times character occurs in cell-values in specificied range.
I have a number of cells which are filled with easy to use characters (only one per cell). However, there are some cells which have 2 or 3 characters in the cell value (example: M/w). I would like t...
OliverScheurich
Oct 29, 2022Gold Contributor
=COUNT(SEARCH("M",B4:G4))
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work wiht Office365 or Excel 2021.