count data set in a single cell

user20052717 0
Viewed 25

I need a different type of calculation. I need to count every 6 digits in personelId column. I tried Len and Countif formulas. I have tried =LEN(E2)-LEN(SUBSTITUTE(E2;"-";""))+1 and =LEN([@PersonelID])/6 etc.But they didn't work. Every six digit is a personelID that I pull data from SQL database. I need to count those personelIDs. Thank you upfront

enter image description here

dataset count excel
2 Answers

You can try something like this :
=COUNTA(TEXT.SPLIT([cell];"-"))

user5l2i10

You can try-

=LEN(E2)-LEN(SUBSTITUTE(E2,"-",""))-1
Harun24hr0
Related