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

2009-11-13 Thread Dhartikumar Sahu
hi Prashanth Please find attached file as per your requirement. Dhartikumar On Thu, Nov 12, 2009 at 6:36 PM, Prashanth Banneni wrote: > Hi All, > > Can you help me how to get the desired output from the attached sheet. > > Many thanks in advance > > Best > Prashanth > > -- > > -

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

2009-11-12 Thread Deepak Rai
:praba...@gmail.com] > *Sent:* 12 November 2009 18:37 > > *To:* excel-macros@googlegroups.com; dilipan...@gmail.com > *Subject:* $$Excel-Macros$$ text and date in one cell > > > > Hi All, > > > > Can you help me how to

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

2009-11-12 Thread Nayan K Lodaya
=CONCATENATE(C3," ",TEXT(D3,"mmm-yy")) Hope this helps From: Prashanth Banneni [mailto:praba...@gmail.com] Sent: 12 November 2009 18:37 To: excel-macros@googlegroups.com; dilipan...@gmail.com Subject: $$Excel-Macros$$ text and date in one cell Hi All, Can you help me ho

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

2009-11-12 Thread Putta Madaiah
Pls check the attachment for solution. Rgds- Putta On Thu, Nov 12, 2009 at 6:36 PM, Prashanth Banneni wrote: > Hi All, > > Can you help me how to get the desired output from the attached sheet. > > Many thanks in advance > > Best > Prashanth > > -- > > ---

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

2009-11-12 Thread Paul Schreiner
Try using: =C3&" "&TEXT(D3,"mmm-yy") Paul From: Prashanth Banneni To: excel-macros@googlegroups.com; dilipan...@gmail.com Sent: Thu, November 12, 2009 8:06:57 AM Subject: $$Excel-Macros$$ text and date in one cell Hi All, Ca

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

2009-11-12 Thread Prashanth Banneni
Hi All, Can you help me how to get the desired output from the attached sheet. Many thanks in advance Best Prashanth -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-