How to Count Comma Separated Values in One Cell in Excel

preview_player
Показать описание
This tutorial video will demonstrate you how to count values in a single cell separated by commas using SUBSTITUTE formula in Excel.

#########
#########
Рекомендации по теме
Комментарии
Автор

Hello, thanks, great tut
Is there a way to do that but also to account for different values for instance put within brackets?
Eg, in the cell you have
“excel (3), word (1), access (5), ppt (2), outlook (1)”
I’d need a function to count also for those values, any help?
Many thanks

Omar-hcuc