Split/Count comma delimited string in OpenCalc

1

I have a cell that is formatted like so : Jill,Bob,Stan etc. Is there a way to count the number of name present in the string?

GSto

Posted 2010-11-03T16:38:30.270

Reputation: 111

Count the commas and add 1 if the string is not null – Chris Nava – 2010-11-03T17:02:04.960

No answers