I have names in the following format(this is just a representation, I have this for hundreds of rows) and I want to know the count of names
enter image description here
How can I get the count of the number of rows in a cell.
In this example I want a formula that could give me 8
I could not find a formula. Count does not work here since it will give 6
New contributor
Rifadh Jeelani is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.