(Reading time: 1 minute)

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,


The output is excatly the same i.e 10th March 2010 , 20:00

Author: Oxygen
Other articles by this author

Chillzee Tag Cloud

Let's Socialize

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.