I think I have the answer I think the following function calculation
would work....

if
a1 contains 18911, 18801, 18825, 18482, 18941

then the following could give me the number of values in the cell

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1


--
Sandih
------------------------------------------------------------------------
Sandih's Profile: http://www.excelforum.com/member.php...o&userid=36225
View this thread: http://www.excelforum.com/showthread...hreadid=560150