View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default If a comma is found

Assumes that A1 contains text:
=IF(ISERROR(FIND(",",A1)),"comma not found","comma found")

Joerg

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

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

Thanks.
--
David P.