without len function count of characters

Key Takeaways

hi guys this is rajik after a long time I used to going to record a video for you guys and one query asked by one of our friend that how to find the suppose actually his question is to count how many two characters length of names are here okay without L function first of all I'll I'll show you with the length function after that I will show you without length function how to find how many characters are there okay the total characters count first of all I'll use the length function Len of this two F9 to evaluate and show wherever it is there 2 3 okay now coming to this equal to this F9 wherever it find the second character two characters length word it will show you the true and remaining are all falses so I'll conver true into falses by double negative and close F9 it will convert to ones and zeros and simply use some product for this okay now I will show you enter now I will show you whenever change it it will change okay okay now I'll show you without L function now keep con uh in Excel question indicates the characters okay one question indicates one character two questions indicate two characters three question indicate three characters so by using this pattern I will show you how to count all those things okay first of all what you will do without length function I'm counting the length characters okay repeat question mark comma this F9 see four are there 1 2 3 4 okay I suspend this one for a while and I will change this to okay I'll do like this F2 not F2 F2 home back enter when I change to three it will five it will change five five question mark when I change to three it will change to three question marks okay when I change to one it will one question mark now I will use this pattern in Formula like ctif count if F2 F4 comma wait a minute I'll press this over here close parenthesis and I press enter now see the mag IC only enter I'm not use the control shift enter it's an array function so I'm not using that one when I change to two how many twos are there see here and here I I'll keep a different different uh this thing for this so that easily you can able to understand that one see this is the formula okay see now when here is the formula here is the formula here is the criteria when to three three four characters okay [Music] no I forgot another query I'll be back with another query also maybe Monday I think so okay because these many days I'm very much busy and if you have any doubts ask me in my telegram group okay guys thank you guys thanks for your support have a nice day