Count list items within cells

[Alder]

I have a column that is either contains a blank or one or more
integers separated by semi-colons. If there are values the
semi-colons allow me to search for particular numbers using the Excel
Find function. There is no trailing semi-colon at the end of the list
of values.

Examples:

<blank>
43458
44344;44545;54233

What I would like is a worksheet function that returns a zero when the
cell is blank, or the number of values in the list.

Any suggestions or pointers would be appreciated. Thanks.

Terry

 

[Alder]

I have a column that is either contains a blank or one or more
integers separated by semi-colons. If there are values the
semi-colons allow me to search for particular numbers using the Excel
Find function. There is no trailing semi-colon at the end of the list
of values.

Examples:

<blank>
43458
44344;44545;54233

What I would like is a worksheet function that returns a zero when the
cell is blank, or the number of values in the list.

Any suggestions or pointers would be appreciated. Thanks.

Terry

I found an answer myself:

=IF(<cellref>="",0,SUM(LEN(<cellref>)-SUM(LEN(SUBSTITUTE(<cellref>,";",""))))+1)

Thanks,

Terry