Counting multiple values in a single cell

Tech-Archive recommends: Fix windows errors by optimizing your registry


I have a cell which contains multiple values set out like this:

3; 4; 7

I would like to be able to count the number of values (3) in this cell.
Does anybody know how I could do this????


--
ac8038
------------------------------------------------------------------------
ac8038's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6054
View this thread: http://www.excelforum.com/showthread.php?threadid=553526

.