combining dates and text in a cell

C

Cecilia

Hello--

I had a column with dates and another with text labels.

I'd like to combine these and tried using this formula:

=D6&" "&I6

D6 = 7/4/2009
I6 = HOLIDAY

Is there any way to do this to get the actual date and not the numberical
value returned?

Thanks in advance for your help.
 
J

JLatham

try
=TEXT(D6,"m/d/yy ") & I6
Notice that I've included the space for separation as part of the format for
the date, saving a little complexity of the formula. You can, of course, use
other formats for the date to get it displayed differently, such as:
=TEXT(D6,"d-mmm-yyyy ")&I6
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To combine various cell formulae in to the final cell 1
conditional formatting of dates 3
Formula 4
conditional statement using validation cell 2
turn a cel a color based o todays date 9
How to keep formula and be able to input value in cell? 0
copying a cell that has been formatted to cell with conditionals 1
Complex Question on Filtering on a merged column 1

Top