I have a cell that has several entries, each entry is separated by ;
and i would like to count how many entries i have in the cell
example:
Subject one - research; subject two - marketing; subject three - Trade
as you see i have three subjects
if i use the function
=SUM(LEN(K12:K718)-LEN(SUBSTITUTE(K12:K718,";","")))
it counts the ;
but as you notice in the example I have three subjects, but only two ;
hope there could be a way to get what i need to count.
Bookmarks