Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Count the number of Bs (uppercase only) in the string

Input the formula: =LEN(A1)-LEN(SUBSTITUTE(A1,"B",""))