how to subtract two words

[varun]

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

 

[John]

Hi
If you can spare extra columns; they can be deleted after.Use Text to
Columns.
Goto Data>Text to Columns>Select Fixed Width>Next>place the arrows between
the names and you should be good.
HTH
John

 

[Rick Rothstein]

Let's say NESTLE CRUNCH is in A1 and CRUNCH is in B1. Put this into the cell
you want the "subtraction" to be in...

=TRIM(SUBSTITUTE(A1,B1,""))

 

[Gary''s Student]

With the full text in A1 and the text to be removed in B1, use:

=SUBSTITUTE(A1,B1,"")