Prev: Function help needed please.
Next: MS Excel 2003 - Advanced Features Add-In
From: NSNR on 4 Mar 2010 10:21
Hi,
How can I concatenate these 2 cells: one is time and the other is text: 9:00
and AM and I want the result to be 9:00 AM
=CONCATENATE(AD2, " ", AE2)
I have tried different formating cells but it doesn't work, this is what I
get:
0.375 AM

Thanks for your help.

From: Daryl S on 4 Mar 2010 11:02
NSNR -

You must format the time (which is a number) to text:

=TEXT(AD2,"H:MM") & " " & AE2

--
Daryl S


"NSNR" wrote:

> Hi,
> How can I concatenate these 2 cells: one is time and the other is text: 9:00
> and AM and I want the result to be 9:00 AM
> =CONCATENATE(AD2, " ", AE2)
> I have tried different formating cells but it doesn't work, this is what I
> get:
> 0.375 AM
>
> Thanks for your help.
>
From: NSNR on 4 Mar 2010 11:16
Thanks Daryl, it worked :)

"Daryl S" wrote:

> NSNR -
>
> You must format the time (which is a number) to text:
>
> =TEXT(AD2,"H:MM") & " " & AE2
>
> --
> Daryl S
>
>
> "NSNR" wrote:
>
> > Hi,
> > How can I concatenate these 2 cells: one is time and the other is text: 9:00
> > and AM and I want the result to be 9:00 AM
> > =CONCATENATE(AD2, " ", AE2)
> > I have tried different formating cells but it doesn't work, this is what I
> > get:
> > 0.375 AM
> >
> > Thanks for your help.
> >
 | 
Pages: 1
Prev: Function help needed please.
Next: MS Excel 2003 - Advanced Features Add-In