Count number of occurrences separated by comma

[Niclal]

Hello All,
In one column with header e.g. "Test1" I have selected a range of data with cells having entries separated by comma. I would like to count the number of entries and put the number in a newly created column right to my column "Test1".
Could you please help me with an Excel macro?
Thank you for your help

Niclal

[nilem]

Hi Niclal,
maybe UDF

Please Login or Register  to view this content.

for example
=NumberOfEntries(A1)

[Niclal]

Hi Nilem,
Thanks for your quick response. Would it be possible to have that as macro, because I'd like to have the number of occurrences in a separate column.
Nic

[Niclal]

Hi everyone,
Any idea how to build this macro?
Thank for your help
Nic