Forum

canapone said Hi, maybe =COUNTIF(A:A,"*-0114*") could do the trick. If you'd need to check the substring (-0114) only in the last 8...

Hi Mynda, Appreciated many thanks. I've gone through the attachment, and the links to understand MID search option. I am sure this will help m...