View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NSNR[_2_] NSNR[_2_] is offline
external usenet poster
 
Posts: 5
Default Concatenate function

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.