| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Threaded Mode
