I have the following data in a separate column:
1) Date - 01/08/2012
2) Time - 9:17:56 AM
I need this two data to be combined in a single text in a separate column which will be resulting --- 01/08/2012 09:17
What formula could I use to convert this two data into "01/08/2012 09:17"?