Here is another approach...

=IF(LEN(A1)=LEN(SUBSTITUTE(A1,",","")),"No comma","There's a comma")

--
Rick (MVP - Excel)


"David P." wrote in message
...
How would I do this?:

=IF(A comma is found in A1),...

Thanks.
--
David P.