Count cells containing specific text
 

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.)

Count cells containing specific text
 

=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.)

Count cells containing specific text
 

Hi

=COUNTIF(YourRangeOfCells,"*shipped*")

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"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.)

Count cells containing specific text
 

Perfect. Thank you.


"Wigi" wrote:

Hi

=COUNTIF(YourRangeOfCells,"*shipped*")

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"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.)

Count cells containing specific text
 

Perfect. Thank you.


"Gary''s Student" wrote:

=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.)