Concatinate, TEXT with date formula.

[srizki]

I have dates in column C, like this 2/28/2017
[TABLE="width: 255"]
<tbody>[TR]
[TD] And text in column H,
[/TD]
[/TR]
</tbody>[/TABLE]
I want result like this,
0217JIB IDC - DRILL SITE TITLE OPINION

Please advise.

Thanks

 

[jproffer]

Where in your result is a date formula....or a date like you said you had in column C?

Or........

Is the 0217 the month and the year?

Maybe this?:

Excel 2013/2016
	A	B	C
1	2/28/2017	Hi there	0217Hi there
2	3/4/2017	How are you	0317How are you
Sheet1

Cell Formulas
Range	Formula
C1	=TEXT(MONTH(A1),"00") & RIGHT(TEXT(YEAR(A1),"00"),2)&B1
C2	=TEXT(MONTH(A2),"00") & RIGHT(TEXT(YEAR(A2),"00"),2)&B2

 

[jproffer]

=TEXT(MONTH(C1),"00") & RIGHT(TEXT(YEAR(C1),"00"),2)&H1

Sorry. Here's one with your requested columns.

 

[Scott Huish]

=TEXT(C1,"mmyy")&H1

 

[srizki]

jproffer

Thank you, your formula is working but as you see Scott's formula is easy so I think I should use the easy one.

Thanks again.

Best regards,

 

[srizki]

Thank you Scott,
This is short and simple.

Best regards,
Sohail

 

[jproffer]

jproffer

Thank you, your formula is working but as you see Scott's formula is easy so I think I should use the easy one.

Thanks again.

Best regards,

I agree, you should use his. I'm not completely familiar with the TEXT function and didn't realize you could do the month and year at the same time. I like his better also . I'll have to work on that function sometime...get more acquainted with it.