Thread: how to subtract two words
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Varun Varun is offline
external usenet poster
  
Posts: 37
Default how to subtract two words
i want to subtract two words for eg:- NESTLE CRUNCH - CRUNCH hence result
should be "NESTLE"
can i have straight formula instead of using LEFT, RIGHT
Reply With QuoteReply With Quote