This topic has been archived. It cannot be replied.
-
工作学习 / 科技领域杂谈 / Help with Excel! Can anyone tell me how to count how many commas in a cell.Thanks.
-xxu99(春眠不觉晓);
2010-10-19
(#6326523@0)
-
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))
-jeffrey815(Smartiecat);
2010-10-19
(#6326539@0)