Hi Amar,
When we use "*instr*" function it give us the first position of the text we
want to search in a string for Example:
"Hindustan Times is an India news paper : 123"
in above string i want to get any word after the Word "Paper" i have to
search word "Paper" first so i will use instr function that will give me
the starting postion of the word "Paper" in the string
ie: 34 Now for getting any word i have to add count of charactors in the
word paper so that 16 is the count of the charactors.
Hope it will be clear to you.
Regards
Prince
On Friday, January 18, 2013 10:52:16 AM UTC+5:30, amar takale wrote:
>
> Thank u so much...Prince,Ashish, Excel Beginner for your kind help.I
> teaching some from this formula.
>
> Thanks very much friends.But i asked Question Ashish & Prince what is 16
> numbers in formula for prince & what is 15 numbers in formula for ashish.
>
>
>
> On Thu, Jan 17, 2013 at 10:31 PM, >>Excel Beginner<<
> <excelb...@gmail.com<javascript:>
> > wrote:
>
>> Hi Amar,
>>
>> Below is the solution to your needs or check the attachment.
>>
>>
>> =--MID($C$2,SEARCH(B6,$C$2)+(LEN(B6))+3,FIND("""",$C$2,SEARCH(B6,$C$2)+(LEN(B6)+3))-(SEARCH(B6,$C$2)+(LEN(B6)+3)))
>>
>>
>>
>>
>>
>> --
>> *Regards,*
>> *
>> *
>> *Excel Beginner*
>>
>> On Thu, Jan 17, 2013 at 7:03 PM, amar takale <amart...@gmail.com<javascript:>
>> > wrote:
>>
>>> All Dear,
>>>
>>> Can you suggest any formula.Pls suggest
>>> Appreciate the help
>>>
>>> Amar
>>>
>>> --
>>> Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com<javascript:>
>>> .
>>> To unsubscribe from this group, send email to
>>> excel-macros...@googlegroups.com <javascript:>.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>>
>>>
>>>
>>
>>
>>
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com<javascript:>
>> .
>> To unsubscribe from this group, send email to
>> excel-macros...@googlegroups.com <javascript:>.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>
>
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
