Re: $$Excel-Macros$$ Re: text and date in one cell

2009-11-15 Thread Dilip Pandey
You are always welcome..!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Nov 15, 2009 at 9:09 PM, Prashanth Banneni wrote: > Hi Dilip, > > Thanks a lot, You are a genius > Thanks > P

Re: $$Excel-Macros$$ Re: text and date in one cell

2009-11-15 Thread Prashanth Banneni
Hi Dilip, Thanks a lot, You are a genius Thanks Prashanth On Sat, Nov 14, 2009 at 10:38 PM, Dilip Pandey wrote: > Hi Prashanth, > > You can use following formula to get the desired output. > =C3&TEXT(D3," MMM-YY") > > Solved workbook is also attached. > Let me know if solves your query > > Best

$$Excel-Macros$$ Re: text and date in one cell

2009-11-14 Thread Dilip Pandey
Hi Prashanth, You can use following formula to get the desired output. =C3&TEXT(D3," MMM-YY") Solved workbook is also attached. Let me know if solves your query Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New De