This is a discussion on Search column of data to find if cells contain a comma? within the Excel Questions forums, part of the Question Forums category; ...
Can anyone help me please?
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?
Idea being A1 is True or False (or other flag value) if range B2:B500 contains a ď,Ē
The comma could be anywhere within any cell within the range. Example of cells within the range:
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.
Many thanks in advance
Microsoft MVP - Excel
Don't be afraid to use volatile functions or array formulas
Tell us what version of Excel you're using
KISS - Keep It Simple Stupid
Thanks, you da man!!! works like a cham.