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, A508 in rows

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 what

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

2013-01-30 Thread Manjunath Narayanappa
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$$ Extract information from excel

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

2013-01-29 Thread amar takale
-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 =MID(B2 ,FIND(K508,B2 ),FIND( ,B2 ,FIND(K508,B2 ))-FIND(K508,B2 )) On Mon, Jan 28

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'm unable

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

2013-01-29 Thread amar takale
] 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'm unable to copy the formula paste in another sheet Thank Manjunath From: excel-macros

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

2013-01-29 Thread amar takale
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 in another sheet Thank Manjunath From: excel-macros

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

2013-01-29 Thread NOORAIN ANSARI
' Subject: RE: $$Excel-Macros$$ Extract information from excel 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

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

2013-01-29 Thread amar takale
To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Extract information from excel Pl see the attached sheet. Why to write too much formula if you want only 8digits alpha. Warm Regards, Gawli Anil On Mon, Jan 28, 2013 at 9:54 PM

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 extract only the highlighted

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