Search column of data to find if cells contain a comma?

[ExcelHound]

Can anyone help me please?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I’m trying to find a way to search a column of data within Excel to detect if a comma exists anywhere within the range to cells?<o></o>
Idea being A1 is True or False (or other flag value) if range B2:B500 contains a “,”<o></o>
The comma could be anywhere within any cell within the range. Example of cells within the range:<o></o>
Dog<o></o>
Cat<o></o>
Bunny<o></o>
,<o></o>
Dog,<o></o>
Cat, Dog<o></o>
Etc<o></o>
<o> </o>
I don’t explicitly need to count the number of times a comma is found, although that would be cool, I just need to be able to flag if a comma exists.<o></o>
<o> </o>
Many thanks in advance<o></o>

 

[T. Valko]

Can anyone help me please?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I’m trying to find a way to search a column of data within Excel to detect if a comma exists anywhere within the range to cells?<o></o>
Idea being A1 is True or False (or other flag value) if range B2:B500 contains a “,”<o></o>
The comma could be anywhere within any cell within the range. Example of cells within the range:<o></o>
Dog<o></o>
Cat<o></o>
Bunny<o></o>
,<o></o>
Dog,<o></o>
Cat, Dog<o></o>
Etc<o></o>
<o></o>
I don’t explicitly need to count the number of times a comma is found, although that would be cool, I just need to be able to flag if a comma exists.<o></o>
<o></o>
Many thanks in advance<o></o>

Try this...

=COUNTIF(B2:B500,"*,*")>0

=COUNTIF(B2:B500,"*,*")

 

[ExcelHound]

Thanks, you da man!!! works like a cham.

 

[T. Valko]

Thanks, you da man!!! works like a cham.

You're welcome. Thanks for the feedback!