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.

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 wrote: > hi Dilip Sir > > Brilliant formula... > > > > On

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 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." > > =MID(MID

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

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 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, Rahul Gan

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. wrote: > Guys, > > I am facing some problem to Extract the A/c no. from Line written in > Particular Cell. > > Ther

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. 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. > > Example. > > A

$$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 = A