How to quickly combine text and date into the same cell in Excel?

Sometimes, when the user is working with large datasets, involves the use of both text and dates. Another important task is to combine the two elements into a single cell. Excel provides simple and efficient methods to merge text and date values effortlessly. In this article, users need to explore different techniques and formulas that will allow users to merge text and date values quickly and seamlessly in Excel. The first example uses the user-defined formula, to combine data and text value. While the second example, allows the user to use the kutools.

Example 1: To combine the text and date into the same cell by using the user defined formula in excel.

Step 1

In this article, the user will learn the process of combining text and date into the same cell. here, the first column comprises the text, the second column comprises the respective dates, and the final column is created to store the result.

Step 2

After that go to the D3 cell, and type formula “=B3&" " &TEXT(C3,"dd-mmm-yyyy")” to cell. snapshot for the same is provided below −

Explanation

• The guided formula allows the user to combine contents from two cells. For this example, the two taken cells are B3 and C3. Finally, the calculated result will be stored in the D3 cell.

• In this formula, a “ ” (space) is used to ensure that both values contain a space between them.

• The text () method allows the user to convert data to text format.

• The & (ampersand) operator represents the concatenation operator in Excel. This operator allows the user to add or combine the text from two available cells.

• The provided TEXT function allows the user to format the date written in C3 cells. The first argument of the created function is the value to be formatted, that is C3 in this case. The second argument is the formatting code "dd-mmm-yyyy" which specifies the desired date format.

• By using the provided formula, the user can easily combine the results of both the provided columns, without any ambiguity with a proper space between them. This space allows the user to categorize the data without any issues.

Step 3

The final obtained concatenated results are shown below −

Step 4

Drag the fill handle to copy the same formula to bottom rows −

Example 2: To combine the text and date into the same cell by using the kutools in Excel.

Step 1

In this example, will understand the process of combining the two columns by using the kutools. Consider an Excel sheet with two columns.

Step 2

Click on the “Kutools” tab, and further select the “Combine” button. Consider the below-depicted image for reference:

Step 3

The above step will display a dialog box, “Combine Columns or Rows”. In the opened dialog box, click on the “Combine columns” buttons. In the “Specify a separator” label, click on the “Space” button. After that in the options area, click on the “Merge the combined cells” option. After that click on the “OK” button.

Step 4

The above step will successfully display the combined cells properly. All the required cell data are combined now, as shown below −

Conclusion

In this article, the user will learn the process of combining text and date data values written in separate columns. This task will allow the user to understand the method to combine data written in separate columns into the same column. All the provided steps are detailed, precise, and thorough. The stepwise explanation provided for the task is easy and efficient. Beginners can also learn all the examples by simply referring to the article's explanation, effectively without any need for a trainer or any external source.