Counting No of character in a string
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. |
Counting No of character in a string
Hi Chandrashekar
Try the below =LEN(A1)-LEN(SUBSTITUTE(A1,";",)) If this post helps click Yes --------------- Jacob Skaria "Chandrashekar B" wrote: 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. |
All times are GMT +1. The time now is 04:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com