• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » How to Combine Text with a Date or Time in Excel

How to Combine Text with a Date or Time in Excel

October 25, 2016

There is no straightforward way to enter a string of text in Excel along with a date or time. Excel simply does not allow you to combine text and dates or text and time together in the same cell. However, there is a simple workaround that makes it possible for you to do this. In this Excel tutorial, we show you how to combine text with a date or time using a simple formula tweak.

How to Combine Text with a Date in Excel

Let’s take an example scenario where I have a string of text in cell A1 called Stock Availability On: In cell B1, I want to enter the current date. And in cell C1, I want to enter the string of text that should read like this Stock Availability On: XXX (the current day’s date). Here’s how to do this:

1. In cell B1, enter the TODAY function to incorporate today’s date. Type=TODAY() and press Enter. If necessary, format the date according to your preference. You can do that by selecting the Home tab and in the Number group, from the Number drop-down list, select a short date. Or go to More Number Formats and in the Number Format dialog box, select a date format of your choice.

entering-todays-date

2. To combine the contents of both cells, we use the & symbol. However, in cell C3, if we type =A1&B1, we will get something like this.

Stock Availability On:42668

combining-text-and-date-wrong-formatting

That’s because Excel treats both the cell values as text. We need to tell Excel to express the date in the proper format, i.e the date format. For this we use the TEXT function. The Text function uses 2 arguments. The first argument is a value, such as a date or a number, which is converted to a text value. The second argument is format_text, which converts the text value in a format that you want. So the text function will read like this:

TEXT(B1,”dd-mm-yy”)

3. Now we need to combine both the functions, which should read:

ALSO READ:  How to Calculate the Number of Work Days Between Two Dates in Excel

=A1&” “&TEXT(B1,”dd-mm-yy”)

How to Combine Text with a Date in Excel

That’s It! You just used the Today and TEXT functions to combine a string of text with a date in Excel.

How to Combine Text with Time in Excel

Just like how you combined a string of text with a date, you can also combine a string of text with time in Excel. Here you’ll use 2 functions to accomplish the task. One is the Now function, which indicates the current time and the other one is the TEXT function, which allows you to display the time in its proper format.

Let’s say we have some text in cell A3 that reads The Time Now is: In cell B3, we want to display the current time and in cell C3, we want to combine the text and time to read The Time Now is: XXX (the current time). To do this:

1. In cell B3, we enter the time function. Type =(NOW(). Again, if necessary, format the time according to your preference. You can do that by selecting the Home tab and in the Number group, from the Number drop-down list, select a time format. Or go to More Number Formats and in the Number Format dialog box, select a time format of your choice.

2. In cell C3, we enter the combination of the text in cell A3 and the TEXT function, which is TEXT(B3,”hh:mm”). So the function will read:

=A3&” “&TEXT(B3,”hh:mm”)

How to Combine Text with Time in Excel

That’s it! You just learned how to combine text with a date or time in Excel and should have no trouble next time you want to do the same.

If you found this tutorial useful, be sure to learn more good stuff in our Learn Excel series. If you want to take up an introductory course on Excel,  consider taking up our Udemy course, Excel 2016 for Beginners. It is available at a nominal price of just $10. As, always, your feedback is much appreciated.

Tweet18
Share2
WhatsApp
Pin2
Buffer
22 Shares

Filed Under: How To Tagged With: excel how to, learn excel

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Amazfit Falcon Smartwatch - TATFI

The Amazfit Falcon is a Military Grade Smartwatch with Premium Looks and Great Features

Couchmaster Cyboss Ergonomic Couch Desk - TATFI

Couchmaster Cyboss is an Ergonomic Desk to Keep Off Neck Pain

Philips Hue Festavia String Lights - TATFI

Add a Bit of Sparkle to Your Christmas Tree with Philips Hue Festavia String Lights

Samsung Galaxy Tab A7 Lite Kids Edition - TATFI

This Kid Friendly Tablet from AT&T is a Thoughtful Gift for Your Little One This Christmas

Is An iPhone Really Worth It - TATFI

Is an iPhone is Really Worth It?

Devices You Might Want to Try - TATFI

4 Fantastic Devices You Might Want to Try

Amazon Kindle 2022 - TATFI

Meet the Amazon Kindle 2022 – Packed with New Features

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Make Money Playing at Fairspin Online Casino - TATFI

Make Money Playing at Fairspin Online Casino

How Mobile Wellbeing Apps are Empowering Patients - TATFI

How Mobile Wellbeing Apps are Empowering Patients

Tips to Boost Your Ranking and Sales on Etsy - TATFI

5 Ways to Boost Your Ranking and Sales on Etsy

PunchBee Time Management App - TATFI

Know How You Spend Your Time with PunchBee

DevOps Model Explained - TATFI

The Complete Guide to DevOps: How the Model Works and Who It Benefits

Approaches to Digital Marketing - TATFI

Blending Technical and Content-Centric Approaches to Digital Marketing

Tech Tips For Startups - TATFI

Useful Tech Tips For Startups

Boox Tab X Android eReader - TATFI

Boox Tab X is an Android eReader That Helps You Do More Than Just Read

Best e Readers to Buy in 2023 - TATFI

5 Best eReaders to Buy in 2023

Best Translation Apps for Android - TATFI

5 Great Translation Apps for Android

Dynamic Island Feature on Your Android - TATFI

How to Get the Dynamic Island Feature on Android

Connected TV Advertising In 2023 - TATFI

5 Things You Need To Know About Connected TV Advertising In 2023

TheAppTimes © 2023 // Runs on StudioPress