Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Count the number of Bs (both upperand lowercase) in the string

Input the formula: =LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE)