Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

How to Count List in 1 Cell on google Sheet?

I want to count how many list in the cell. I have a table like this

enter image description here

And I don’t know how to count that list so it can make out put like this

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

enter image description here

I’m sorry I’m not using the table to ask in here because I don’t know how to use list on the table. You can Access the sheet here : sheet2
Thanks!

>Solution :

try:

=INDEX(LEN(REGEXREPLACE(A2:A4, "[^\.]", )))

enter image description here

Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading