Counting No of character in a string

  • Thread starter Thread starter Chandrashekar B
  • Start date Start date
C

Chandrashekar B

Hi,

I have a data for ex a;b;c;d in a cell if i find ";" excel formula should
display result as 3 because no of occurence of ";" in a cell is 3.

I need a excel formula to do this help me out.
 
Hi Chandrashekar

Try the below
=LEN(A1)-LEN(SUBSTITUTE(A1,";",))

If this post helps click Yes
 
Back
Top