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
-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.98246F90
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312
From
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 amit...@iocl.co.in wrote:
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
** **
Can anybody suggest a suitable formula ?
**
Hi,
you can use this formula as well in cell B2:-
=LOOKUP(99^99,--(0MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A20123456789)),ROW(INDIRECT(1:LEN(A2))
Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY amit...@iocl.co.in wrote:
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
, 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,8,9,0
, 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@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf