See the attached
In this sheet Data Is a name Range which return Formula for cells
=SUM(--(NOT(ISNUMBER(INT(MID(data,ROW(INDIRECT("1:"&LEN(data))),1))
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of santosh subudhi
Sent: Mar/Sun/201
Hi Santosh,
See the attached file where I have achieved this using formulas only.
Thanks.
Regards,
DILIPandey
On Sun, Mar 18, 2012 at 1:27 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Group,
>
> I have added "=2+2" in cell A1 and in cell A2 I want the result to be 2
> since
