1. 

   bantu
   

   Member
   Joined: Aug '10
   Posts: 3

   What formula is applicable for adding to cells contaning one text & the other cell contaning number/date.

   Posted 2 years ago #
2. 

   oldchippy
   

   Member
   Joined: Dec '09
   Posts: 464

   Hi bantu,

   If your text is in A1 and your date is in B1 then

   =A1&TEXT(B1," dd-mm-yyyy")

   Note the space between the first " and dd so that this separates your text from your date

   Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums