Forum Discussion
GHubb2125
Mar 25, 2023Copper Contributor
Counting entries within a single cell
I am looking to count entries within a cell, and am assuming the best way to do so is to remove the "=" from the start and have a count function count how many "+" there are and add one to it. I am t...
HansVogelaar
Mar 25, 2023MVP
With such a formula in A1:
=LEN(FORMULATEXT(A1))-LEN(SUBSTITUTE(FORMULATEXT(A1),"+",""))+1