Dear Group,
The winner of this puzzle has been selected as Manoj. His formula is
shortest and working very well. The formula is =MONTH(1&A1).
I will publish the same on the blog with his name.
Congratulations Manoj !
Thank you all for participating! The new puzzle is on the way....STAY TUNED
.
Thanks & Best Regards,
Ayush Jain
Group Manager & Microsoft MVP
On Thu, Jan 6, 2011 at 7:33 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
> given the string is in Cell A1,
> use:
>
> = MONTH("01-"&LEFT(A1,3))
>
> Paul
>
> ------------------------------
> *From:* ayush jain <jainayus...@gmail.com>
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, January 6, 2011 1:26:42 AM
>
> *Subject:* Re: $$Excel-Macros$$ Excel Puzzle of the week
>
> there was Typo in example...its Decem to 12
>
> Submit your answer now. :D
>
> Thnx again.
>
> On Thu, Jan 6, 2011 at 11:54 AM, Ayush <jainayus...@gmail.com> wrote:
>
>> Dear members,
>>
>> There is a excel puzzle for you. Let see who all can give the answer
>> correctly.
>>
>> There is a data of [month] in excel with no fixed length , minimum three
>> characters, text format. You need to develop formula (Not Macro) which can
>> convert it into number.
>> For example
>> Jan to 1
>> March to 3
>> Apr to 4.
>> Decem to 5.
>> & so on.
>>
>> The best formula(short & relevant) & winner name will be published on
>> exceldailytip.blogspot.com blog of this group.
>>
>> Let see who is the first and who is the winner.
>>
>> Thank you.
>>
>> Best Regards,
>> Ayush Jain
>> Group Manager & Microsoft MVP
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Best regards,
> Ayush Jain
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Best regards,
Ayush Jain
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
