(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,

 
 
 
=CONCATENATE(A1," , ",TEXT(B1,"HH:MM"))
 
 
 

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


Chillzee Tag Cloud

About Chillzee

Chillzee.com is an entrepreneurship portal.

The site provides informative topics on Organizational and Strategic needs.