Concatenate Colums A, B and C into D, but B is a Date and A and C are String values

[trenzalore888]

Hello! Please could anyone help me find either a VBA code to concatenate or if not a Formula to achieve this in the desired format:

I have 3 columns, A, B and C. I want to concatenate all three values into Column D. The problem is that A and C are String, and B is a date, so when concatenated, the D column changes the date to a number value instead of keeping the date dd/mm/yyyy. I have tried changing the formats of the cell several times/different combinations but doesn't work.

For example:

Desired result in D1:
A1 B1 C1 D1
CAT 30/01/2014 Dog CAT30/01/2014dog

What I actually get:
A1 B1 C1 D1
CAT 30/01/2014 Dog CAT41669Dog




Thank you in advance for any help

[AliGW]

Maybe like this:

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

[trenzalore888]

Perfect! thank you so much!

[AliGW]

You're welcome!