Count multiple strings from one cell (not a dropdown list column)
Please help with a formula to count strings in a cell. I receive an Excel export file which contains a string of values in a cell. This is my objective (and a few notes):
1) Subitems Column. Every single value is unique and there are a few thousand.
a) Count total number of values in the cell (almost like a "word" count?). Do not need to single out unique values.
I tried to convert the cell into a dropdown list to see if it would separate the values and then create a simple count formula but that didn't work. The result is each entire cell string is created as a "value" in the dropdown list.
Thank you for your help. This community is full of super smart, kind and helpful people!
Help Article Resources
Check out the Formula Handbook template!