View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default If a comma is found

Another one:

=IF(COUNT(FIND(",",A1)),.....

Note that this doesn't work on numbers using a number comma format (10,000)


--
Biff
Microsoft Excel MVP


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

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

Thanks.
--
David P.