If no comma found
Hi,
To add flexibility enter the search item in another cell, say C1 and then
=IF(SEARCH(C1,A1),"found","not found")
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"David P." wrote:
What formula would accomplish:
If no comma found in A1 then...
--
David P.
|