#1
|
|||
|
|||
Concatenate text and a date
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 |
#2
|
|||
|
|||
Something like:
=AC3&" "&TEXT(AF3,"dd-mm-yyyy") |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
I have tried to build onto to your formula, but I just can't seem to get it right.
|
#5
|
|||
|
|||
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? |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
I see, thank you for your help.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenate | b16 | Excel | 1 | 01-09-2017 04:51 PM |
how to concatenate text box on new slide | wichitawx | PowerPoint | 5 | 05-19-2015 05:17 AM |
Concatenate with @ symbol | anickles | Excel | 2 | 02-06-2015 09:39 AM |
Adding text before a date merge field AND fomatting date as well | NikkiR | Mail Merge | 1 | 08-06-2014 07:18 PM |
If, move and concatenate in VBA | devcon | Excel Programming | 0 | 07-04-2011 12:44 AM |