Let's assume that you have following contents in your excel sheet:
A1 - 10th March 2010
B1 - 20:00
Say, now you want to concatenate A1 and A2 and display in the cell A3. There are two ways to do the same.
1. Using &
The formula used to perform this looks as below:
=A1 & " , " & TEXT(B1,"HH:MM")"
When we enter the above formula in the cell D1, the cell content has 10th March 2010, 20:00
2. Using Concatenate function
The formula used here is,
=CONCATENATE(A1," , ",TEXT(B1,"HH:MM"))
The output is excatly the same i.e 10th March 2010 , 20:00
