Table of Contents
To concatenate text and date in Excel means to combine or merge both a text value and a date value into a single cell. This can be useful when creating reports or organizing data. To do so, you can use the “&” symbol or the CONCAT function in Excel. For example, to concatenate the text “Today is” with the date “January 1st, 2021”, you can use the formula = “Today is” & ” ” & A1, where A1 is the cell containing the date. This will result in the cell displaying “Today is January 1st, 2021”. By using this method, you can easily merge text and date values in Excel for various purposes.
Concatenate Text & Date in Excel (With Example)
When using the CONCAT function, Excel will automatically convert dates to numeric values.
However, you use the TEXT function to specify that the date should remain formatted as a date:
=CONCATENATE(A2,TEXT(B2,"M/DD/YYYY"))
This particular formula will concatenate the strings in cells A2 and B2 and keep the date in cell B2 formatted as a date with a M/DD/YYYY format.
The following example shows how to use this formula in practice.
Example: Concatenate Text & Date in Excel
Suppose we have the following dataset in Excel that contains information about the start date for various employees at some company:
If we use the following CONCAT function to create a string that describes when each employee started working, each of the dates in column B will be converted to numeric values by default:
=CONCAT(A2, " started working on ",B2)
Notice that each of the dates have been converted to numeric values by default.
To concatenate the cells and keep the dates in column B formatted as dates, we can instead use the following formula:
=CONCAT(A2, " started working on ", TEXT(B2, "M/DD/YYYY"))
By using the TEXT function within the CONCAT function, we are able to concatenate the employee names and the dates while keeping the dates in the correct format.
Also note that M/DD/YYYY is only one date format option we could have used.
=CONCATENATE(A2, " started working on ", TEXT(B2, "MMM YYYY"))
Feel free to use whichever date format you’d like within the TEXT function.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How do I concatenate text and date in Excel? (With example). PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-concatenate-text-and-date-in-excel-with-example/
stats writer. "How do I concatenate text and date in Excel? (With example)." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-concatenate-text-and-date-in-excel-with-example/.
stats writer. "How do I concatenate text and date in Excel? (With example)." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-concatenate-text-and-date-in-excel-with-example/.
stats writer (2024) 'How do I concatenate text and date in Excel? (With example)', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-concatenate-text-and-date-in-excel-with-example/.
[1] stats writer, "How do I concatenate text and date in Excel? (With example)," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I concatenate text and date in Excel? (With example). PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.