Microsoft Office Forums - View Single Post - [Solved] Concatenate text and a date

Thread: [Solved] Concatenate text and a date

View Single Post

Old

11-15-2018, 09:06 AM

Joanne

Joanne is offline

Joanne uses Windows 7 32bit

Windows 7 32bit Joanne uses Office 2010 32bit

Joanne uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Jul 2013

Posts: 58

Joanne is on a distinguished road

Default

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?

Reply With Quote