Q . How can I count a specific character in a single cell ?
Ans. In simple way there in no way to count a character in a single cell, but you can do it with different way.
Follow this
Step1. Calculate length of the Cell with “=Len” formula. Shown below-
Step2. Substitute special character, with “=Substitute”
Formula. See image below-
Step3. Find length of the cell after substitute.See image below-
Step4.Calculate Substitute of both lens (step2.-step3.). See image -
Step5. Merge the all formulas. see image-
Click here to get Exercise file Count A Specific Character in a Single Column .Thanks In advance.
0 comments:
Post a Comment