Counting items in a cell separated by comma

AJM_FD · 10/09/24

Hello,

Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma.

Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community.

Thank you again!

Nic Larsen · 10/09/24

This solution found in this older post should work:

Nic Larsen · 10/09/24

This solution found in this older post should work:

AJM_FD · 10/09/24

Thank you!

Best Answer