| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to subtract two words
Hi
If you can spare extra columns; they can be deleted after.Use Text to Columns. Goto DataText to ColumnsSelect Fixed WidthNextplace the arrows between the names and you should be good. HTH John "varun" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to subtract two words
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,"")) -- Rick (MVP - Excel) "varun" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to subtract two words
With the full text in A1 and the text to be removed in B1, use:
=SUBSTITUTE(A1,B1,"") -- Gary''s Student - gsnu200832 "varun" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert numeric to words Example 525 in words (Twenty five | Excel Discussion (Misc queries) | |||
| Subtract | Excel Worksheet Functions | |||
| how do i add and subtract | New Users to Excel | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
| Add IF or Subtract IF?? | Excel Worksheet Functions | |||
Linear Mode
