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
