Thread: Counting No of character in a string
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chandrashekar B Chandrashekar B is offline
external usenet poster
  
Posts: 1
Default 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.
Reply With QuoteReply With Quote