Thread: How do I concatenate information in Excel and keep the number form
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I concatenate information in Excel and keep the number
=TEXT(A1,"dd/mm/yyyy ") & TEXT(B1,"hh:mm:ss")

Note the <space added after yyyy


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 09:23:01 -0700, asynmyx
wrote:

I tried Bob Phillip's formula and it works except the date and time do not
have a space between them for easier reading. I also tried to suggestion
after that and it did not work. Any suggestions?

Reply With QuoteReply With Quote