Combine text and date into same cell in Excel
In Excel, when combining the text and date from two columns into one same cell, normally, you may apply the & character to join the two cells, but, the date will be converted to the number format. To solve this problem, you can combine the TEXT function into the formula. This article, I will talk about how to use formulas to deal with this job in Excel.
- Combine two columns of text and date into same cell with & symbol
- Combine two columns of text and date into same cell with CONCATENATE function
Combine two columns of text and date into same cell with & symbol
In Excel, you can use the & symbol to join the two cells, and apply the TEXT function to keep the date format, the generic syntax is:
- text: The text string or cell value that you want to combine.
- char: A specific delimiter that separate the combined data.
- date: The date or cell value that you want to combine.
- mm/dd/yyyy: The date format that you want to use, you can change it to your need.
Please copy or enter the following formula into a blank cell where you want to get the result:
Then, drag the fill handle down to the cells that you want to apply this formula, and the text and date into different cells have been merged into one cell, see screenshot:
Combine two columns of text and date into same cell with CONCATENATE function
Here, you can also use the CONCATENATE function to achieve this task quickly and easily. The generic syntax is:
- text: The text string or cell value that you want to combine.
- char: A specific delimiter that separate the combined data.
- date: The date or cell value that you want to combine.
- yyyy-mm-dd: The date format that you want to use, you can change it to your need.
Please apply the below formula into a blank cell:
And then, drag the fill handle down to fill this formula to other cells you need, and you will get the result as below screenshot shown:
Note: Sometimes, you may need to combine the text with today’s date, in this case, you can apply the following formula:
Relative functions used:
- CONCATENATE:
- The Excel CONCATENATE function is used to join two or more text items from multiple cells into one.
- TEXT:
- The TEXT function converts a value to text with a specified format in Excel.
More articles:
- Combine Date And Time Into One Cell In Excel
- Combining dates and times from two different columns into one single column as below screenshot shown, here will introduce some simple methods for dealing with task in Excel.
- Move Or Combine Multiple Cell Contents Into One Cell
- This tutorial will talk about how to combine multiple cell contents into one single cell as below screenshot shown. In Excel, you can use the & symbol, CONCATENATE or TEXTJOIN function to solve this task quickly and easily.
- Combine Cells With Line Break
- In Excel, sometimes, you may want to combine cells into one cell with line break as below screenshot shown. Here, in this tutorial, it introduces two formulas to solve this task with examples.
- Combine First Initial And Last Name
- Here are two columns in a sheet in Excel, one contains first names, the another one contains last names. In this tutorial, it provides a formula to combine the first initial of the first name and the last name into one cell.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300 powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) and save 80% time for you.
- Designed for 1500 work scenarios, helps you solve 80% Excel problems.
- Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
- Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
- 30-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years.
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Firefox, And New Internet Explorer.
