in Cell A1,
>>> use:
>>>
>>> = MONTH("01-"&LEFT(A1,3))
>>>
>>> Paul
>>>
>>> --
>>> *From:* ayush jain
>>>
>>> *To:* excel-macros@googlegroups.com
>>> *Sent:*
:
>
>> given the string is in Cell A1,
>> use:
>>
>> = MONTH("01-"&LEFT(A1,3))
>>
>> Paul
>>
>> --------------
>> *From:* ayush jain
>>
>> *To:* excel-macros@googlegroups.com
>> *Sent:
given the string is in Cell A1,
use:
= MONTH("01-"&LEFT(A1,3))
Paul
From: ayush jain
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...i
i agreed with Manoj
see the attachment
thanks & regards
On Thu, Jan 6, 2011 at 12:20 PM, Manoj kumar wrote:
> how about this...
>
> =MONTH(1&A1)
>
>
> Regards,
> Manoj Kumar
>
>
> On Thu, Jan 6, 2011 at 12:05 PM, ayush jain wrote:
>
>> Wow AshishSuperfast...I liked it..
>>
>> Dear group,
how about this...
=MONTH(1&A1)
Regards,
Manoj Kumar
On Thu, Jan 6, 2011 at 12:05 PM, ayush jain wrote:
> Wow AshishSuperfast...I liked it..
>
> Dear group,
> Do you have better answer to beat ashish :P
>
>
> On Thu, Jan 6, 2011 at 11:57 AM, ashish koul wrote:
>
>> check the attachment
>>
Wow AshishSuperfast...I liked it..
Dear group,
Do you have better answer to beat ashish :P
On Thu, Jan 6, 2011 at 11:57 AM, ashish koul wrote:
> check the attachment
>
> MONTH(VALUE(LEFT(A1,3)&1))
>
> On Thu, Jan 6, 2011 at 11:54 AM, Ayush wrote:
>
>> Dear members,
>>
>> There is a excel p
check the attachment
MONTH(VALUE(LEFT(A1,3)&1))
On Thu, Jan 6, 2011 at 11:54 AM, Ayush 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 for
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 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 ,
