: 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
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
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
(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
...@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
@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
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
: $$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
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
How to collect only numeric value from a particular cell
1462NIRM 1462
1464NIRM 1464
1465NIRM 1465
1404--BL 1404
1031Infr 1031
8020LOKN 8020
202D.B. 202
922Parmi 922
5071RIFA 5071
1040Harj 1040
5078Harj 5078
1471Raj 1471
1571Raj 1571
414Ruchi 414
2084AJAY 2084
Regards
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
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,
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
@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
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
:* 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
16 matches
Mail list logo