Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Text Functions

 

A case-insensitive comparison

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