I want to count the number of commas in a cell, and use that to calculatehow many separate bits of info (batch numbers) are within that cell. I have a formula (probably over-complicated) that works for two variables, but I want to count up to 3 or more. I also want it as simple as possible.
the approach is to get the length of the cell, then substitute all commas in the cell with nothing, get the length of that and then subtract one from the other. That will give you the count of commas in the cell. Add 1 to return the count of elements in the cell.