return a string ending with specific value in excel code example Example: return a string ending with specific value in excel =COUNTIF(B4,"*ota")