Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread LAKSHMAN PRASAD
: RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell Hi,   If your data in  Alphanumeric value in A1 then use it in B1   =IFERROR(SUM(INT(MID(A1,LARGE(--ISNUMBER(INT(MID(A1,ROW(INDIRECT(1:LEN(A1))),1)))*ROW(INDIRECT(1:LEN(A1))),ROW(INDIRECT(1:SUM(--ISNUMBER(INT(MID(A1,ROW

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread LAKSHMAN PRASAD
Sent: Tuesday, May 29, 2012 11:57 AM Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Dear Lakshman,Please see attached sheet, It is working fine..Let's know where are you facing problem.-- Thanks regards, Noorain Ansari www.noorainansari.com

RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread Asa Rossoff
To: excel-macros@googlegroups.com Sent: Tuesday, May 29, 2012 11:57 AM Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Dear Lakshman,Please see attached sheet, It is working fine..Let's know where are you facing problem.-- Thanks regards, Noorain Ansari

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread dguillett1
(rng, i, 1) End If Next i End Function Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Tuesday, May 29, 2012 1:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Dear

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread NOORAIN ANSARI
...@gmail.com *Sent:* Tuesday, May 29, 2012 1:27 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Dear Lakshman, Please see attached sheet, It is working fine.. Let's know where are you facing problem. -- Thanks

RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread Rajan_Verma
@googlegroups.com] On Behalf Of Deba Ranjan Sent: 29 May 2012 10:36 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Dear experts, its a awesome expertise work. Now - Can we extract only words and numbers separately from Alphanumeric

RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread Rajan_Verma
Great J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: 29 May 2012 6:49 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from

RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread Rajan_Verma
: $$Excel-Macros$$ How to collect only numeric value from a particular cell Hi, You can try ths =LOOKUP(99^99,--(0MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A10123456789 )),ROW($1:$1 On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.com wrote: How to collect only numeric

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-29 Thread dguillett1
Only gets the numbers left of text Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Tuesday, May 29, 2012 8:19 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Hi

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-28 Thread Anil Gawli
On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: How to collect only numeric value from a particular cell ** 1462NIRM 1462 1464NIRM 1464 1465NIRM 1465 1404--BL 1404 1031Infr 1031 8020LOKN

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-28 Thread anil kumar
Hello anil, I will try your formula but i could not get same result. how it work plz discraibe. Regards same here -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

RE: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-28 Thread Rajan_Verma
Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell Function removetext(c As String) Dim String1 As String Dim i As Integer String1 = For i = 1 To Len(c) If IsNumeric(Mid(c, i, 1

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-28 Thread Deba Ranjan
@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *vishal angre *Sent:* 28 May 2012 4:52 *To:* excel-macros@googlegroups.com *Cc:* noorain.ans...@gmail.com *Subject:* Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-28 Thread Ashish Bhalara
2012 4:52 *To:* excel-macros@googlegroups.com *Cc:* noorain.ans...@gmail.com *Subject:* Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell ** ** Function removetext(c As String) Dim String1 As String Dim i As Integer String1

Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell

2012-05-28 Thread Deba Ranjan
:* noorain.ans...@gmail.com *Subject:* Re: $$Excel-Macros$$ How to collect only numeric value from a particular cell ** ** Function removetext(c As String) Dim String1 As String Dim i As Integer String1 = For i = 1 To Len(c