## Excel Formula: Combine Date and Text into One Cell

As above screenshot shown, to combine date and text together, formulas can help you in Excel.

Generic formula

text&" "&TEXT(date,date_format)
or
CONCATENATE(text," ", TEXT(date,date_format))

Syntaxt and arguments

 Text: the cell refers to the text or a text string enclosed with double quotation marks that you want to combine with date. Date: a cell refers to the date or a date enclosed with double quotation marks that you want to combine with text. Date_format: the date formatting that you want the date displayed, it needs to be enclosed with double quotation marks.

Date format list

 Date_format Date displayed as (1/2/2021) d 2 dd 02 ddd Sat dddd Saturday m 1 mm 01 mmm Jan mmmm. January mmmmm J yy 21 yyyy 2021 Mm/dd/yyyy 01/02/2021 m/d/y 1/2/21 Ddd,mmm d Sat,Jan 2

Return value

How this formula works

In the column A, range A3:A4, listing the text, in column B, range B3:B4, listing dates, now to combine the texts and dates into cells, please use the formula as these:

In cell C3

=A3&" "&TEXT(B3,"mm/dd/yyyy")

Directly using text and date in the formula

In cell C4

=CONCATENATE(A4," ", TEXT(B4,"mm/dd/yy"))

Directly using text and date in the formula

=CONCATENATE("The start date is"," ", TEXT("12/31/2021","mm/dd/yy"))

Press Enter key to get result.

Explanation

TEXT function: to convert a number to a text in a specified format.

As we known, the date is stored as number in Excel, and to convert the date to a text and display as a specified date format, TEXT function can do the favor.

CONCATENATE function: to merge two or more texts items from multiple cells into one.

T=&: to join texts together.

Extension

To combine start date and end date together to show as a duration in text format, please use below formula:

=TEXT(A7,"mm/dd/yyyy")&"-"&TEXT(B7,"mm/dd/yyyy")

Or

=CONCATENATE(TEXT(A7,"mm/dd/yy"),"-",TEXT(B7,"mm/dd/yy"))

### The Best Office Productivity Tools

#### Kutools for Excel - Helps You To Stand Out From Crowd

 🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions… Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ... Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup... Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List... Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Columns to Select Same & Different Cells ... Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ... Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

#### 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, Edge and Firefox.