, July 05, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Use this In B2
=MID(SUBSTITUTE(TRIM(A2)," ","*",2),FIND("*",SUBSTITUTE(TRIM(A2),"
","*",2),1)+1,11)
From: excel-macros@googlegr
, 2011 2:38 PM
To: excel-macros@googlegroups.com
Subject: RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Hi,
Here is another option. It is slightly shorter, and doesn't produce a #VALUE!
error when the target cell does not contain the expected data.
=MID(A2,MIN(SEARCH({1,2,3,4,5,6,7,
Hi,
you can use this formula as well in cell B2:-
=LOOKUP(99^99,--("0"&MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))
Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY wrote:
> I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
>
> ** *
r
sample, then the formula could be further reduced to:
=MID(A2,MIN(SEARCH({1,3},A2&13)),11)
Regards - Dave.
From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Date: Tue, 5 Jul 2011 14:24:00 +0530
U
hi Ajay
try this
=MID(B2,FIND(" ",B2,FIND(" ",B2)+1),FIND(" ",B2,FIND(" ",B2,FIND("
",B2)+1)+2)-FIND(" ",B2,FIND(" ",B2)+1))
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY wrote:
> I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
>
> ** **
>
> Can anybody suggest a suitable formula ?
>
>
:07 PM
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
Can anybody suggest a suitable formula ?
With Warm Regards,
CA. Ajay Mittal
Finance Manager
cid:image001.jpg@01CC1029.9824
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
Can anybody suggest a suitable formula ?
With Warm Regards,
CA. Ajay Mittal
Finance Manager
[cid:image001.jpg@01CC3B1C.C8978CC0]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312
From: excel-macros@googlegroups.com [mailto:excel-macros@google
