If a comma is found
I like this one best... one function call. Let's remove the comparison just
to shorten it up a bit...
=IF(COUNTIF(A1,"*,*"),"found","not found")
--
Rick (MVP - Excel)
"Dave Peterson" wrote in message
...
One mo
=if(countif(a1,"*,*")0,"found","not found")
David P. wrote:
How would I do this?:
=IF(A comma is found in A1),...
Thanks.
--
David P.
--
Dave Peterson
|