Posted to microsoft.public.excel.misc

Varun

external usenet poster

Posts: 37

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to convert numeric to words Example 525 in words (Twenty five	Ganta Amar Nath	Excel Discussion (Misc queries)	2	July 17th 08 10:21 AM
Subtract	Chi	Excel Worksheet Functions	0	April 1st 08 02:52 PM
how do i add and subtract	kim	New Users to Excel	4	December 22nd 07 12:10 AM
how do i insert words into a column without erasing the words	soccer5585	Excel Discussion (Misc queries)	0	June 8th 05 11:06 PM
Add IF or Subtract IF??	RJ	Excel Worksheet Functions	4	November 30th 04 09:03 PM

All times are GMT +1. The time now is 10:34 AM.

About Us

"It's about Microsoft Excel"