While working in Microsoft Excel, it is very common that we have to work on combining data from multiple columns in a worksheet in Microsoft Excel 2010.
Let’s take an example of Column A and Column B
In our excel worksheet, Column A contains First Name and Column B contains Last Name. We can either use Concatenate Formula or we can use “&”
Combining Date and Time Value from separate Columns into a single Cell
We have seen how to combine data from 2 columns. Similarly, let’s see how to combine date and time which are present in 2 different columns into one column.
Let’s take an example of Column A and Column B.
Column A contains Date and Column B contains Time.
Column A contains 11/23/2014 and Column B contains 2:30:54 PM.
We want the answer as "11/23/20142:30:54 PM"
There are 2 ways to get this result:
Formula 1: =TEXT(A1,"dd/mm/yyy")&" "&TEXT(B1,"hh:mm:ss")
Formula 2: =a1+b1
Columns A:F contain values representing month, day, year, hours, minutes and seconds.
We want to combine the numbers from each row into a single date and time value.
Use the DATE and TIME functions as shown in the following formula:
Format the results (column G) as "mm/dd/yy hh:mm:ss".
In this way we can join date & time from two cells into one cell.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.