18C123,18C234,18C345,18C456,18C567
呢啲數字係同一格入面
有冇formula可以計到C出現既次數?
正在瀏覽這個版面的使用者: Majestic-12 [Bot] 和 28 位訪客
mtr 寫: Try using "SUBSTITUTE" and "LEN" functions like the example below :
https://exceljet.net/formula/count-spec ... -in-a-cell
For instance, you place this whole bunch in cell "A1" :
"18C123,18C234,18C345,18C456,18C567"
Paste this formula at another cell, see if it can give the correct count "5"
=LEN(A1)-LEN(SUBSTITUTE(A1,"C",""))