Find and count instances of a character in a string in Excel
I want to count the number of commas in a cell, if any.
tells me the location of the first comma (2), but I want the total number of commas to be returned (7). I've been using a laborious character-by-character check from 1 to len(string) and incrementing the variable CommaCount every time it finds a comma, but I'm pretty sure there's an easier way.
try the forllowing formula
(for formulas, depending on your country, you might have to change ; with , or the opposite