Adding string after the dates in a column

[srizki]

Hi all,

I copy dates from another sheet and paste in column, K and then format as 30-Sep-17. I need to add [.C01709503.BIL] . to the date,. without brackets. The addition will always be the same all the way.
Or in anther way, I am combining two columns, date and AFE (C01709503) adding .BIL at the end. at the same time I need to format date as dd-mm-yy.
So the final will become
[TABLE="width: 163"]
<tbody>[TR]
[TD]31-OCT-17.C01709503.BIL
[/TD]
[/TR]
[TR]
[TD]31-DEC-17.C01709503.BIL
[/TD]
[/TR]
[TR]
[TD]31-SEP-17.C01709503.BIL
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there a faster way of adding the string [.C01709503.BIL ] after the dates.
Regards,

 

[Joe4]

If your date was in cell A1, and your AFE in cell B1, then this formula should do what you want:

=TEXT(A1,"dd-mm-yy") & "." & B1 & ".BIL"

 

[srizki]

Thank you Joe.

 

[Joe4]

You are welcome.