Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

Return the number of occurrences of a substring in B1 within a string in A1

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