=COUNTIF(A:A,"*shipped*")

--
Gary''s Student - gsnu200738


"dandiehl" wrote:

I have a column of free text cells that describe an action that was taken. I
would like to identify any cells that contain the word "shipped". (Shipped
will never be the only word in the cell, it is always part of a string of
text.)