Re: $$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread dguillett1 
And you could combine into ONE formula

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com

From: ashish koul 
Sent: Sunday, June 03, 2012 6:25 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ How to find paritcular word from sentence

check the attachment see if it helps 


On Sun, Jun 3, 2012 at 2:09 PM, SUDHIR VERMA  wrote:

  Dear Ashish,

  Thank you so much and Please can u explain this for understanding me.


  thanking you


  On 03/06/2012, ashish koul  wrote:
  > check the attachment see if it helps
  >
  > On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA  wrote:
  >
  >> Dear All,
  >>
  >> Please resolved below query.
  >>
  >> Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
  >> dt: 6.8.11, by NTU.
  >> Being accounts credited as per GR No: 100486  dt: 5.9.11, Bill no 889,
  >> dt: 4.9.11 by Fedex.
  >> Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through
  >> Nalagarh Truk Union.
  >>
  >>
  >> I have more than 500 sentences like above and every time i want found
  >> GR No.. dt:..
  >> in separated column (Result Like below)
  >>
  >> GR No: 785, dt: 6.8.11
  >> GR No: 100486  dt: 5.9.11
  >> gr no 56478789
  >>
  >>
  >> thanking you
  >>
  >> regards
  >> sudhir
  >>
  >> --
  >> FORUM RULES (986+ members already BANNED for violation)
  >>
  >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
  >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
  >> will not get quick attention or may not be answered.
  >>
  >> 2) Don't post a question in the thread of another member.
  >>
  >> 3) Don't post questions regarding breaking or bypassing any security
  >> measure.
  >>
  >> 4) Acknowledge the responses you receive, good or bad.
  >>
  >> 5)  Cross-promotion of, or links to, forums competitive to this forum in
  >> signatures are prohibited.
  >>
  >> NOTE  : Don't ever post personal or confidential data in a workbook.
  >> Forum
  >> owners and members are not responsible for any loss.
  >>
  >>
  >> 
--
  >> To post to this group, send email to excel-macros@googlegroups.com
  >>
  >> To unsubscribe, send a blank email to
  >> mailto:excel-macros%2bunsubscr...@googlegroups.com
  >
  >
  >
  >
  > --

  > *Regards*
  > * *
  > *Ashish Koul*
  > *http://www.excelvbamacros.com/*
  > *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/>

  >
  >
  > P Before printing, think about the environment.
  >

  > --
  > FORUM RULES (986+ members already BANNED for violation)
  >
  > 1) Use concise, accurate thread titles. Poor thread titles, like Please
  > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
  > not get quick attention or may not be answered.
  >
  > 2) Don't post a question in the thread of another member.
  >
  > 3) Don't post questions regarding breaking or bypassing any security
  > measure.
  >
  > 4) Acknowledge the responses you receive, good or bad.
  >
  > 5)  Cross-promotion of, or links to, forums competitive to this forum in
  > signatures are prohibited.
  >
  > NOTE  : Don't ever post personal or confidential data in a workbook. Forum
  > owners and members are not responsible for any loss.
  >
  > 
--
  > To post to this group, send email to excel-macros@googlegroups.com
  >
  > To unsubscribe, send a blank email to
  > mailto:excel-macros%2bunsubscr...@googlegroups.com

  --
  FORUM RULES (986+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security measure.

  4) Acknowledge the responses you receive, good or bad.

  5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

  NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

  
--
  To post to this group, send email to excel-macros@go

Re: $$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread ashish koul 
*check the attachment see if it helps *

On Sun, Jun 3, 2012 at 2:09 PM, SUDHIR VERMA  wrote:

> Dear Ashish,
>
> Thank you so much and Please can u explain this for understanding me.
>
>
> thanking you
>
> On 03/06/2012, ashish koul  wrote:
> > check the attachment see if it helps
> >
> > On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA 
> wrote:
> >
> >> Dear All,
> >>
> >> Please resolved below query.
> >>
> >> Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
> >> dt: 6.8.11, by NTU.
> >> Being accounts credited as per GR No: 100486  dt: 5.9.11, Bill no 889,
> >> dt: 4.9.11 by Fedex.
> >> Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through
> >> Nalagarh Truk Union.
> >>
> >>
> >> I have more than 500 sentences like above and every time i want found
> >> GR No.. dt:..
> >> in separated column (Result Like below)
> >>
> >> GR No: 785, dt: 6.8.11
> >> GR No: 100486  dt: 5.9.11
> >> gr no 56478789
> >>
> >>
> >> thanking you
> >>
> >> regards
> >> sudhir
> >>
> >> --
> >> FORUM RULES (986+ members already BANNED for violation)
> >>
> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> >> will not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
> >>
> >> NOTE  : Don't ever post personal or confidential data in a workbook.
> >> Forum
> >> owners and members are not responsible for any loss.
> >>
> >>
> >>
> --
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> To unsubscribe, send a blank email to
> >> excel-macros+unsubscr...@googlegroups.com
> >
> >
> >
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *http://www.excelvbamacros.com/*
> > *http://www.accessvbamacros.com/* 
> >
> >
> > P Before printing, think about the environment.
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5)  Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE  : Don't ever post personal or confidential data in a workbook.
> Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or

Re: $$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread SUDHIR VERMA 
Dear Ashish,

Thank you so much and Please can u explain this for understanding me.


thanking you

On 03/06/2012, ashish koul  wrote:
> check the attachment see if it helps
>
> On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA  wrote:
>
>> Dear All,
>>
>> Please resolved below query.
>>
>> Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
>> dt: 6.8.11, by NTU.
>> Being accounts credited as per GR No: 100486  dt: 5.9.11, Bill no 889,
>> dt: 4.9.11 by Fedex.
>> Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through
>> Nalagarh Truk Union.
>>
>>
>> I have more than 500 sentences like above and every time i want found
>> GR No.. dt:..
>> in separated column (Result Like below)
>>
>> GR No: 785, dt: 6.8.11
>> GR No: 100486  dt: 5.9.11
>> gr no 56478789
>>
>>
>> thanking you
>>
>> regards
>> sudhir
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* 
>
>
> P Before printing, think about the environment.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread ashish koul 
check the attachment see if it helps

On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA  wrote:

> Dear All,
>
> Please resolved below query.
>
> Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
> dt: 6.8.11, by NTU.
> Being accounts credited as per GR No: 100486  dt: 5.9.11, Bill no 889,
> dt: 4.9.11 by Fedex.
> Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through
> Nalagarh Truk Union.
>
>
> I have more than 500 sentences like above and every time i want found
> GR No.. dt:..
> in separated column (Result Like below)
>
> GR No: 785, dt: 6.8.11
> GR No: 100486  dt: 5.9.11
> gr no 56478789
>
>
> thanking you
>
> regards
> sudhir
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/* 


P Before printing, think about the environment.

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

SAMPLE.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ How to find paritcular word from sentence

2012-06-03 Thread SUDHIR VERMA 
Dear All,

Please resolved below query.

Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
dt: 6.8.11, by NTU.
Being accounts credited as per GR No: 100486  dt: 5.9.11, Bill no 889,
dt: 4.9.11 by Fedex.
Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through
Nalagarh Truk Union.


I have more than 500 sentences like above and every time i want found
GR No.. dt:..
in separated column (Result Like below)

GR No: 785, dt: 6.8.11
GR No: 100486  dt: 5.9.11
gr no 56478789


thanking you

regards
sudhir

-- 
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com