How to Combine Text and Date into one Cell in Excel

This post will guide you how to combine text and dates in the same cell in Excel. How do I combine text and date values into one Cell in Excel 2013/2016.

Combine Text and Date into One Cell

Assuming that you have a list of data in range B1:C4, and one column contain product names and another column contain date values, and you want to combine both text and date data into one cell. If you just use concatenate operator to combine those two cells, the date value will be displayed as serial number. This is not your expected. See below screenshot:

combine text and data into one cell1

To combine Text and date into one cell, you need the TEXT function to change the date format from series number to a text. So you can use the following formula based on the TEXT function:

=B1 & “ “ TEXT(C1,”MM/DD/YYYY”)

Type this formula into a blank cell such as: Cell D1, and drag the AutoFill Handle down to other cells.

combine text and data into one cell2

Related Functions

  • Excel Text function
    The Excel TEXT function converts a numeric value into text string with a specified format. The TEXT function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The syntax of the TEXT function is as below: = TEXT (value, Format code)…
Related Posts

Phone Number Format in Excel

Sometimes when we import phone numbers from external sources, the formatting of the phone numbers is removed. Even if in some situations the phone numbers are not imported from external resource, sometimes the phone numbers in worksheet are not displayed ...

Add Leading Zeros in Excel

To pad a number with zeros, you need to add leading spaces and/or carriers. For example, if the original digit contains 2 digits, three additional characters will be added on before it. If there are 3 digits in total, allocating ...

How to Auto Fill Weekdays or Weekends in Excel

Sometimes we may want to enter a sequence of days in excel for some purpose, and we can press Ctrl+; to insert current date into cell, and then drag the cell down to attach following days into other cells, then ...

How to Change Date to The Day of Week in Excel

In excel, we can type a date properly if set cell format as ‘Date’. If there is a list includes multiple dates, is there any way to convert these dates to the days of week accordingly? Actually, there are some ...

How to Create Increment Number with Texts in Excel

Sometimes we want to fill 1,2,3,4,5… into each cell in a column, for implement this we can enter 1 in the first cell and then drag fill handle down to fill the following cells. But if there are some texts ...