RE: $$Excel-Macros$$ Extract information from excel

2013-01-30 Thread Manjunath Narayanappa
s case can we give if function and extract looking information to D column Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: 28 January 2013 15:37 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extrac

Re: $$Excel-Macros$$ Extract information from excel

2013-01-30 Thread Paul Schreiner
This does not provide NEARLY enough information! What do you mean by "extract"? Are you wanting to "find" the string of characters? what are you going to do with them? where do you want them to be put? are you trying to determine if the strings exist in the list? are you trying to determine if wha

Re: $$Excel-Macros$$ Extract information from excel

2013-01-30 Thread अनिल नारायण गवली
Dear Manjunath, see the attached sheet. Warm Regards, Gawli Anil On Wed, Jan 30, 2013 at 4:21 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Experts > > > > Thanks to all, > > > > Please find the attachment, please advise in case if we have K508 ,F508, > E508, A50

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
r Anil, >>>> >> Yes,I am not used countifs formula.pls suggest Excel 2003 formula >>>> >> Thanks in Advance >>>> >> >>>> >> On Tue, Jan 29, 2013 at 3:45 PM, Manjunath Narayanappa >>>> >> wrote: >>&g

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread NOORAIN ANSARI
; From: excel-macros@googlegroups.com > >> > [mailto:excel-macros@googlegroups.com] > >> > On Behalf Of Manjunath Narayanappa > >> > Sent: 29 January 2013 10:14 > >> > To: 'excel-macros@googlegroups.com' > >> > Subjec

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
groups.com >> > [mailto:excel-macros@googlegroups.com] >> > On Behalf Of Manjunath Narayanappa >> > Sent: 29 January 2013 10:14 >> > To: 'excel-macros@googlegroups.com' >> > Subject: RE: $$Excel-Macros$$ Extract information from e

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
ehalf Of Manjunath Narayanappa > Sent: 29 January 2013 10:14 > To: 'excel-macros@googlegroups.com' > Subject: RE: $$Excel-Macros$$ Extract information from excel > > > > Dear Gawli Ali, > > > > I'm unable to copy the formula & paste i

RE: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread Manjunath Narayanappa
sorry to miss spell your name From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manjunath Narayanappa Sent: 29 January 2013 10:14 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Extract information from excel Dear Gawli Ali, I&#

RE: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread Manjunath Narayanappa
Dear Gawli Ali, I'm unable to copy the formula & paste in another sheet Thank Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?? Sent: 29 January 2013 04:53 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$

Re: $$Excel-Macros$$ Extract information from excel

2013-01-29 Thread amar takale
l-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >> On Behalf Of ashish koul >> Sent: 28 January 2013 15:28 >> To: excel-macros@googlegroups.com >> Subject: Re: $$Excel-Macros$$ Extract information from excel >> >> >> >> try t

RE: $$Excel-Macros$$ Extract information from excel

2013-01-28 Thread Manjunath Narayanappa
Thank you very much Ashish, its working fine From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: 28 January 2013 15:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extract information from excel try this see if it helps

Re: $$Excel-Macros$$ Extract information from excel

2013-01-28 Thread ashish koul
try this see if it helps =MID(B2&" ",FIND("K508",B2&" "),FIND(" ",B2&" ",FIND("K508",B2&" "))-FIND("K508",B2&" ")) On Mon, Jan 28, 2013 at 8:41 PM, Manjunath Narayanappa < manjunath.narayana...@aon.co.uk> wrote: > Dear Team, > > > > In above attachment I have a data from which I want to extr