Hi all

I am trying to concatenate the following, but I can't get my formula to work correctly.

In cell AC3 - the words "Installation"
In cell AF3 - is the installation date
In cell AH3 - the words " Warranty Expires"
In cell AK3 - is the expiration date

Can someone please help me with the correct formula as my dates are appearing as numbers.



Many thanks

Something like:

=AC3&" "&TEXT(AF3,"dd-mm-yyyy")

Hi Xor

Thank you, but I am trying to get all four cells into the same column, so it looks like:
Installed 15.11.2018 Warranty Expires 14.11.2019

I have tried to build onto to your formula, but I just can't seem to get it right.

Ok, I have come up with the following and it works

=(AC3&" "&TEXT(AF3,"dd-mm-yyyy")) & (AH3&" "&TEXT(AK3,"dd-mm-yyyy"))

But, how do I get a space between the first and second parts of the formula please?

The same way Xor added a space in each formula
=(AC3&" "&TEXT(AF3,"dd-mm-yyyy")) &" "&(AH3&" "&TEXT(AK3,"dd-mm-yyyy"))

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I see, thank you for your help.