Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

Hi Rahul, Thanks for the title, but let me convey the message that I am not Master and I am also learning with all the members like you. Though you have used many Names in the spreadsheet, which is time consuming on one front, but that's ok. It is good. Best Regards, -- DILIP KUMAR PANDEY

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

Hi Rahul, Considering the following points, below is the formula designed to cater them all. 1) There may be digit 9 which can come earlier also. 2) There may by spaces and periods after A/C No. =MID(MID(C7,FIND(A/c,C7),30),FIND(9,MID(C7,FIND(A/c,C7),30)),10) Above formula assumes that text

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

hi Dilip Sir Brilliant formula... On 19/01/2010, Dilip Pandey dilipan...@gmail.com wrote: Hi Rahul, Considering the following points, below is the formula designed to cater them all. 1) There may be digit 9 which can come earlier also. 2) There may by spaces and periods after A/C No.

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

Dear Ankkur, Thanks for the encouraging words...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Tue, Jan 19, 2010 at 4:50 PM, ankur ankurpande...@gmail.com wrote: hi Dilip Sir Brilliant

$$Excel-Macros$$ How to Extract Data from a Line written in a cell.

Guys, I am facing some problem to Extract the A/c no. from Line written in Particular Cell. There is only 2 Unique things 1. A/c No. should be starts from 9. 2. Length of A/c no. is 10 digits. Example. A1 = EMI of Rs. 800 From A/c No. 9089655463 A2 = From A/c No. 9826438564 Debt EMI 300 A3 =

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

hi rahul plz attach sample file On 19/01/2010, Rahul Gandhi. myname.ra...@gmail.com wrote: Guys, I am facing some problem to Extract the A/c no. from Line written in Particular Cell. There is only 2 Unique things 1. A/c No. should be starts from 9. 2. Length of A/c no. is 10 digits.

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

Ichek it F(NOT(ISERROR(FIND(No.,A1))),MID(A1,FIND(No.,A1)+4,10),IF(NOT(ISERROR(FIND(No,A1))),MID(A1,FIND(No,A1)+3,10), )) On Tue, Jan 19, 2010 at 12:17 AM, Rahul Gandhi. myname.ra...@gmail.comwrote: Guys, I am facing some problem to Extract the A/c no. from Line written in Particular Cell.

Re: $$Excel-Macros$$ How to Extract Data from a Line written in a cell.

hi rahul check this this will work in any format +MID(A1,FIND(9,A1,1),10) On 19/01/2010, ashish koul koul.ash...@gmail.com wrote: Ichek it F(NOT(ISERROR(FIND(No.,A1))),MID(A1,FIND(No.,A1)+4,10),IF(NOT(ISERROR(FIND(No,A1))),MID(A1,FIND(No,A1)+3,10), )) On Tue, Jan 19, 2010 at 12:17 AM,