how to subtract two words

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
 
J

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
 
R

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,""))
 
G

Gary''s Student

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

=SUBSTITUTE(A1,B1,"")
 

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
How do I aucto subtract? 3
subtract times with a negative result 1
How can I subtract cells in two different worksheets? 2
Subtracting two cells-one has existing formula???? 7
Trying to create formula... 12
Subtracting number of days excluding the weekend 2
If Tuesday subtract 4 (Formulas) 3

Top