View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Formula Exclusions?

Trying to do exlude one item from an equation. Is there a easy way for
example:

RIGHT(N11,2)<"ab",

but want to keep the one circumstance of: "cab", but get rid of the rest of
the frab

thanks..