HansVogelaarMVPJan 19, 2023Re: Excel - how to count the number of cells that have a specific word in a columnLucie666 =NB.SI(A1:A100; "*substitution*")