=A2&" "&B2&" "&TEXT(C2,"HH:MM AM/PM")
Use the above formula
On Thu, Oct 30, 2008 at 11:15 AM, vinu <[EMAIL PROTECTED]> wrote:
>
> Hi this works well.
> How to concotenat the time formate for eg:
> MS Exce 12:15 AM how to do this..
>
> Regrds,
> vinu.
>
> On Oct 29, 9:18 am, "Bhavish Poddar"
Hi this works well.
How to concotenat the time formate for eg:
MS Exce 12:15 AM how to do this..
Regrds,
vinu.
On Oct 29, 9:18 am, "Bhavish Poddar" <[EMAIL PROTECTED]> wrote:
> Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy")
> where A1 = MS
> B1 = Excel
> C1 = 29-0ct-08
>
> On Fri
Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy")
where A1 = MS
B1 = Excel
C1 = 29-0ct-08
On Fri, Oct 24, 2008 at 11:31 AM, H Upadhyay <[EMAIL PROTECTED]>wrote:
> Pls chk attached file
>
> Regards
> Harish Upadhyay
>
>
>
> On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>
Hi,
Use the below formula.
=A1&B1&TEXT(C1,("dd-mm-yy"))
On 10/26/08, karthik balasubramanian <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Use this formulae:
>
> =CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-;@"))
>
> COL: E F G ROW ms excel 24-oct-2008
>
> E17 is m
Hi,
Use this formulae:
=CONCATENATE(E17,F17,TEXT(G17,"[$-409]d-mmm-;@"))
COL: E F G ROW ms excel 24-oct-2008
E17 is ms
F17 is excel
g17 is 24-oct-2008
I hope this helps.
with regards
karthik.B
On Fri, Oct 24, 2008 at 1:01 AM, H Upadhyay <[EMAIL PROTECTE
Dear Shyam,
Below is the formula for your query
*=CONCATENATE(A1&B1&""&TEXT(C1,"dd-mmm-yy"))*
regards,
siva
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
> out with this:
>
> Query:
>
> Colum
Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy"))
where D8 = MS
D9= Excel
D10 = 24 - Oct - 08
u will get the answer.
On Fri, Oct 24, 2008 at 7:04 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
>
hi shyam
can u try this one
=CONCATENATE(D12," ",D13," ",TEXT(D14,"dd-mmm-"))
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
> out with this:
>
> Query:
>
> Column A : MS
> Column B : Exc
Hi Gyanesh,
Thanks so much Its working fine... :)
Cheers
Shyam
2008/10/24 gyanesh jain <[EMAIL PROTECTED]>
> Use this =CONCATENATE(D8," ",D9," ",TEXT(D10,"dd-mmm-yy"))
>
> where D8 = MS
> D9= Excel
> D10 = 24 - Oct - 08
>
> u will get the answer.
>
> On Fri, Oct 24, 2008 at 7:04 AM, [EMAI
Hi Dear,
Use formula =A1&" "&B1&" "&TEXT(C1,"D-MMM-YY").
Regards
CA. Atul Singhal
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: October 24, 2008 7:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Concatenate Formula
Hi All,
I have an
hi.
do one thing first paste special the cell value which has date then try
concatenation
On 10/24/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
> out with this:
>
> Query:
>
> Column A : MS
> Column B
Hi,
Pls gohead with this attachment.
WISH U HAPPY DIWALI
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Thu, 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
From: [EMAIL PROT
Pls chk attached file
Regards
Harish Upadhyay
On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have an issue while using concatenate formula, Can any one of you help me
> out with this:
>
> Query:
>
> Column A : MS
> Column B : Excel
> Column C : 24- Oct-08 ( formated
13 matches
Mail list logo
