Extract First 6 digits and convert to date

[srizki]

Hi all,

I have the following, (a partial list).
[TABLE="width: 222"]
<colgroup><col></colgroup><tbody>[TR]
[TD="align: right"]1220160070029210[/TD]
[/TR]
[TR]
[TD="align: right"]0620180070029213[/TD]
[/TR]
[TR]
[TD="align: right"]0120170070029213[/TD]
[/TR]
[TR]
[TD="align: right"]1120160070029210[/TD]
[/TR]
[TR]
[TD="align: right"]0420170070029213[/TD]
[/TR]
</tbody>[/TABLE]
I need to first 6 digits as for example, Dec-16, Jun-18 etc.
I can not use =LEFT(F4,6)
There must be an addition to this above formula.

Thanks,

 

[jtakw]

Hi,

Book1
	A	B	C
1	1220160070029210		Dec-16
2	0620180070029213		Jun-18
3	0120170070029213		Jan-17
4	1120160070029210		Nov-16
5	0420170070029213		Apr-17
6
7			Column custom format mmm-yy
Sheet159

Cell Formulas
Range	Formula
C1	=VALUE(LEFT(A1,2)&"/"&MID(A1,3,4))

C1 formula copied down.
Results converted to Real Date Values.
Format formula cells, "Custom", mmm-yy

EDIT: If you want the result as Text, let me know.

 

[Tetra201]

Or this:
=--LEFT(REPLACE(A1,3,,"/"),7)

 

[srizki]

Thank you Tetra.

 

[Tetra201]

You are welcome.