View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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.