Re: $$Excel-Macros$$ Understand Formula

2011-11-08 Thread Aamir Shahzad
SAM evaluation may be just checking the formula, your description is too enough but can you further brief the structure. Aamir Shahzad On Tue, Nov 8, 2011 at 10:52 PM, Sam Mathai Chacko wrote: > So the formula is just trying to extract a word in a sentence that is > wrapped between double quote

Re: $$Excel-Macros$$ Understand Formula

2011-11-08 Thread Sam Mathai Chacko
So the formula is just trying to extract a word in a sentence that is wrapped between double quote. So if the sentence is for example This is "Sam" The result of the formula would be Sam How the formula works is simple if you know how search works. So I'll just explain how search works The Sea

$$Excel-Macros$$ Understand Formula

2011-11-08 Thread Aamir Shahzad
Hello Group, Following formula is working fine & picking desire word from cell within colons, Only "MID" & "SEARCH" formula is understandable but I am not understanding the syntax of this formula how is it working? Please brief & tell me why +1 & -1 added. How to make & understand of these ty