Re: $$Excel-Macros$$ Excel Puzzle

2011-07-24 Thread Michael Brumby
Rajan, A most excel-ant game, thank you for sharing.   Kind Regards. Michael Brumby Diese Email und samtliche beigefugten Anhange sind vertraulich zu behandeln und sind vor Veroffentlichung geschutzt. Informieren Sie den Absender bitte umgehend und loschen Sie diese Nachricht mit allen be

Re: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar

2011-01-10 Thread Dilip Pandey
in Cell A1, >>> use: >>> >>> = MONTH("01-"&LEFT(A1,3)) >>> >>> Paul >>> >>> -- >>> *From:* ayush jain >>> >>> *To:* excel-macros@googlegroups.com >>> *Sent:*

Re: $$Excel-Macros$$ Excel Puzzle of the week - Winner is Manoj Kumar

2011-01-09 Thread Manoj kumar
: > >> given the string is in Cell A1, >> use: >> >> = MONTH("01-"&LEFT(A1,3)) >> >> Paul >> >> -------------- >> *From:* ayush jain >> >> *To:* excel-macros@googlegroups.com >> *Sent:

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-06 Thread Rohan Young
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,

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread Manoj kumar
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 >>

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ayush jain
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

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ashish koul
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

Re: $$Excel-Macros$$ Excel Puzzle of the week

2011-01-05 Thread ayush jain
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 ,