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
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
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
-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
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
]
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
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
'
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
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
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
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
11 matches
Mail list logo