If no comma found
Try this:
=IF(ISERROR(SEARCH(",",A1)), etc
or
=IF(NOT(ISNUMBER(SEARCH(",",A1))), etc
You can also use FIND instead of SEARCH.
Hope this helps.
Pete
On Dec 9, 12:30*am, David P. wrote:
What formula would accomplish:
If no comma found in A1 then...
--
David P.
|