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
