Combine the Date and Text in the Same Excel Cell.

Posted on February 13, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Combine the Date and Text in the Same Excel Cell.

We already had an Excel Tip & Trick where we combined the use of Text and Numbers in the same Excel Cell. If you want to combine text and the date for the same Excel Cell it works a bit different.

 

If you want to combine the date and text in MS Excel you’ll need to take the following steps.

 

  • Select Cell A1 and give it a value like “Real Time”
  • Select Cell C1 and fill in a date or type in the formula: =TODAY()

 

Excel-tip-trick-pic1

 

  • Now select Cell A5 and type in the following formula:                       =A1&" "&TEXT(C1;"MM/DD/YYYY")

 

Excel-tip-trick-pic2

 

And now you have combined the date and text in one single Excel Cell.

 

Excel-tip-trick-pic3

 

I hope you all liked this Excel Tip and Trick, I’ll see you all tomorrow.

Do you want to see more? This is related...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





Comments

Leave a Reply