Count cells containing specific text

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count cells that begin with specific text	=?Utf-8?B?bW1lciBhdCBzdGVlbGNhc2U=?=	Microsoft Excel Worksheet Functions	9	25th Jul 2006 09:03 PM
If two cells have specific text to count as 1	=?Utf-8?B?SmF6em1hbjEw?=	Microsoft Excel Worksheet Functions	4	26th Jun 2006 05:09 PM
how do I count cells containing only specific text?	=?Utf-8?B?YWNjb3VudGFudA==?=	Microsoft Access	2	31st Aug 2005 07:46 PM
How i count cells that includes a specific text?	Excadrix	Microsoft Excel Misc	1	21st Mar 2004 09:30 AM
What is the formula to count cells with specific text	=?Utf-8?B?Q29uZnVzZWQ=?=	Microsoft Excel Misc	2	7th Mar 2004 10:14 AM