21
{Tricks} Excel Formulas to Combine Text And Date Into Same Cell!!
If you enter the date and text value directly in Excel, the date is displayed as a serial number and not as a date format. To join date and text value without affecting the date format or as per custom format we need to use the Excel TEXT function. In this tutorial, we will explain how to combine the text and date into the same cell in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- Use the below formula to join the text and date into the same cell in Excel.
=”text”&TEXT(date,format)
- TEXT – This function helps to convert a number to text in the given format. Read more on the TEXT function.
- Format – It represents the date formats.
- Date – It specifies the input dates from your worksheet.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Minus Operator (-) – This symbol will help to subtract any two values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Let’s consider the below example image.
- First, we will enter the date in Column B.
- Here we have to combine the date into text with different formats given in Column D.
- Select any cell and type the above-given formula.
- Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.
Hope you like this article on how to combine the text and date into the same cell in Excel. If you have any other ideas or question , do share with us here in the comments section below.
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
21