warded message --
>> From: ayush jain
>> Date: Sat, Jan 8, 2011 at 2:49 PM
>> Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar
>> To: excel-macros@googlegroups.com
>> Cc: manoj.vishwakarma...@gmail.com
>>
>>
>> Dear
Thanks :)
Regards,
Manoj Kumar
On Sat, Jan 8, 2011 at 2:58 PM, Maries wrote:
> Congrats Mr.Manoj..
>
> -- Forwarded message --
> From: ayush jain
> Date: Sat, Jan 8, 2011 at 2:49 PM
> Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj
Congrats Mr.Manoj..
-- Forwarded message --
From: ayush jain
Date: Sat, Jan 8, 2011 at 2:49 PM
Subject: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar
To: excel-macros@googlegroups.com
Cc: manoj.vishwakarma...@gmail.com
Dear Group,
The winner of this puzzle
* 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...its Decem to 12
>
> Submit your answer now. :D
>
> Thnx again.
>
> On
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
Thanks Ashish , Manoj & Maries...Your solutions are great !!
Maries, We can ignore Value formula from your solution and it still work ...
like =TEXT(A11&1,"m")
Till now, Manoj's formula is smallest and easiest ...
Any one else wanna solve or comment on puzzle?
Regards,
Ayush Jain,
Microsoft
$$Excel-Macros$$ Excel Puzzle of the week
To: excel-macros@googlegroups.com
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
>
>
>
$$Excel-Macros$$ Excel Puzzle of the week
To: excel-macros@googlegroups.com
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
>
>
>
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 ,
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
14 matches
Mail list logo