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
>
> --
>
> -
Hi,
U can use =C3 & " " & TEXT(D3,"mmm-yy").
Regards,
Deepak Rai
On Thu, Nov 12, 2009 at 7:36 PM, Nayan K Lodaya wrote:
> =CONCATENATE(C3," ",TEXT(D3,"mmm-yy"))
>
> Hope this helps
>
>
>
> *From:* Prashanth Banneni [mailto:praba...@gmail.com]
> *Sent:* 12 November 2009 18:37
>
> *To:* excel-
=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 how to get the desired outpu
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
>
> --
>
> ---
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,
Can you help me how to get the desir
