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 <samde...@gmail.com>wrote: > Bravo Noorain > > Rgds, > Sam > > > On Thu, Oct 27, 2011 at 1:23 PM, NOORAIN ANSARI > <noorain.ans...@gmail.com>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 >> >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> >> On Thu, Oct 27, 2011 at 1:10 PM, Anjul Porwal <porwalan...@gmail.com>wrote: >> >>> 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. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Sam Mathai Chacko > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel