Counting No of character in a string

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.
 
J

Jacob Skaria

Hi Chandrashekar

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIFS ? 1
Counting one Character as a String 1
Cell data entering slow! 0
List items based on the count given 4
Remove Identical words 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How can I count deviations between two rows? 4

Top