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
t: Re: $$Excel-Macros$$ How to collect only numeric value from a
particular cell
Hi,
You can try ths
=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"
)),ROW($1:$1
On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD
wrote:
How to
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 a
egards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@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
lesAid 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 Lakshman,
>
> Please see
AS = ONSAS & Mid(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
particu
quot;1:"&LEN(A1))),1))),1)*10^ROW(INDIRECT("1:"&SUM(--ISNUM
BER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))))/10,"")
Thanks Noorain
LAKSHMAN
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Tuesday, May 29, 2012 11:57
From: NOORAIN ANSARI
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&
om [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
Function removetext(c As String)
Dim Stri
("1:"&LEN(A1))),1)))*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))),1)*10^ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))
(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(INDIRECT("1:"&LEN(A1))),1))),1)*10^ROW(INDIRECT("1:"&SUM(--ISNUMBER(INT(MID(A1,ROW(INDIREC
LEN(A1))),1/10,"")
> *
>
> ** **
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *vishal angre
>
ups.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
Function removetext(c As String)
Dim String1 As String
Dim i As Integer
String
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, Code
On Mon, May 28, 2012 at 4:30 PM, LAKSHMAN PRASAD wrote:
> How to collect only numeric value from a particular cell
> **
>1462NIRM
> 1462
> 1464NIRM
> 1464
> 1465NIRM
> 1465
> 1404--BL
> 1404
> 1031Infr
> 1031
> 8020LOKN
> 8020
>
15 matches
Mail list logo
