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

Returning next item in list 1
To combine various cell formulae in to the final cell 1
Creating a Search using a combo box and then creating a report. 4
conditional formatting of dates 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Drop Down List Dependant Formula 2
turn a cel a color based o todays date 9
conditional statement using validation cell 2

Top