Re: $$Excel-Macros$$ calculate multiple value in one cell

Thanks SAM. On Thu, Oct 27, 2011 at 9:49 PM, Sam Mathai Chacko wrote: > Bravo Noorain > > Rgds, > Sam > > > On Thu, Oct 27, 2011 at 1:23 PM, NOORAIN ANSARI > wrote: > >> Dear Anjul, >> >> Please see attached sheet, hope it will help to u... >> >> >> Step 1 Select Cell B1 2 Formula-Define Name-Re

Re: $$Excel-Macros$$ calculate multiple value in one cell

And here's the VBA version Function EVALUATER(rngCell As Range) EVALUATER = Application.EVALUATE("=" & rngCell.Value) End Function Regards, Sam Mathai Chacko (GL) On Thu, Oct 27, 2011 at 9:49 PM, Sam Mathai Chacko wrote: > Bravo Noorain > > Rgds, > Sam > > > On Thu, Oct 27, 2011 at 1:23

Re: $$Excel-Macros$$ calculate multiple value in one cell

Bravo Noorain Rgds, Sam On Thu, Oct 27, 2011 at 1:23 PM, NOORAIN ANSARI wrote: > Dear Anjul, > > Please see attached sheet, hope it will help to u... > > > Step 1 Select Cell B1 2 Formula-Define Name-Refers > to-type-=Evaluate($A2) 3 Give Name Range 4 Use Name Range in B1 Cell to > Output >

Re: $$Excel-Macros$$ calculate multiple value in one cell

Dear Anjul, Please see attached sheet, hope it will help to u... Step 1 Select Cell B1 2 Formula-Define Name-Refers to-type-=Evaluate($A2) 3 Give Name Range 4 Use Name Range in B1 Cell to Output -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ calculate multiple value in one cell

Hi, I have multiple value in one cell for example. *A1* 1*7+5 12*57+54 12+854 14+47*1 I want result below type by formula & VBA. *B1* 12 738 866 61 Regards, Anjul -- -- Some important links for excel users: 1. Foll