SAM evaluation may be just checking the formula, your description is too
enough but can you further brief the structure.
Aamir Shahzad
On Tue, Nov 8, 2011 at 10:52 PM, Sam Mathai Chacko <samde...@gmail.com>wrote:
> So the formula is just trying to extract a word in a sentence that is
> wrapped between double quote.
>
> So if the sentence is for example
>
> This is "Sam"
>
> The result of the formula would be Sam
>
> How the formula works is simple if you know how search works. So I'll just
> explain how search works
>
> The Search function returns the number of the character at which a
> specific character or text string is first found, reading left to right and
> is not case sensitive. So search("""",A5) will give the position of " in a
> sentence. There is an argument to specify from which character the search
> should start. So if you specify a position AFTER the first ", it will try
> to find the next occurrence of "
>
> Hope this is clear. To view how your formula is working, you can also use
> the evaluate feature in the formula tab section of excel.
> Regards,
> Sam
>
>
> On Tue, Nov 8, 2011 at 10:39 PM, Aamir Shahzad
> <aamirshahza...@gmail.com>wrote:
>
>> Hello Group,
>>
>> Following formula is working fine & picking desire word from cell within
>> colons, Only "MID" & "SEARCH" formula is understandable but I am not
>> understanding the syntax of this formula how is it working? Please brief &
>> tell me why +1 & -1 added. How to make & understand of these types of
>> formulas.
>>
>>
>> =MID(A5,SEARCH("""",A5)+1,SEARCH("""",A5,SEARCH("""",A5)+1)-SEARCH("""",A5)-1)
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>> --
>> FORUM RULES (925+ 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
> --
> FORUM RULES (925+ 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
>
--
Regards,
Aamir Shahzad
--
FORUM RULES (925+ 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
