Text Functions MSOfficeExcel 2007 Tutorial

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