how to subtract two words

  • Thread starter Thread starter varun
  • Start date Start date
V

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
 
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
 
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,""))
 
With the full text in A1 and the text to be removed in B1, use:

=SUBSTITUTE(A1,B1,"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing Currency format from one worksheet to another 2
Column sum incorrect upon subtracting 6
World Community Grid ---- PCReview Crew II 15
Negative time displaying as ##### 7
subtract times with a negative result 1
Subtracting Rounded Numbers 6
how do I set up a simple subtraction between two cells 1
Subtracting two cells-one has existing formula???? 7

Back
Top