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
>
> --
>
> -
: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
=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
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,
Ca
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-