Trying to merge cells, but dates become values

I need to merge E2 and C2 into D2.

So i need D2 to look like "1/31/2019 First Name" and I need a formula that i can copy down about 10,000 rows. I have tried Contat and ambersand merging but the date keeps showing as a value of 43496. So, using those methods returns "43496 First Name"

Try this in D2:

=TEXT(E2,"m/d/yyy")&" "&C2

concat and ampersand are the same difference.. you will always get the same results as they do exactly the same thing..
you will need to tell excel how to format the datenumber when you merge them into textstrings. Dates are always numbers presented as dates by a formatmask on the cell.

try

Please Login or Register  to view this content.

that should do the trick

or

Please Login or Register  to view this content.

Originally Posted by 63falcondude

Try this in D2:

=TEXT(E2,"m/d/yyy")&" "&C2

THANKS! +rep

Happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.