Many Formulas in one cell

[jewpal]

Hello knowledgeable users!

I am trying to fix a series of numbers. in E2 it reads:

20180809173450Z

I want it to be:

08092018

This is what I have so far:
=MID(E2,7,2)&LEFT(E2,LEN(E2)-9)
Which returns 09201808.

Ok almost there, just have to do that same thing to put 08 in front of the 092018.

=MID(E2,7,2)&LEFT(E2,LEN(E2)-9)&RIGHT(E2,2)

AHCK it does not work! I get:

092018080Z So it seems that the formula is still using what is in E2 and not the "new result." Any advice would be greatly appreciated!!

<colgroup><col width="283"></colgroup><tbody>
</tbody>

 

[jtakw]

Just curious, do you need the results converted to Real Date values for further comparison?

 

[jewpal]

I do, but I think I will be able to solve that

 

[jtakw]

Nothing to solve, use these formulas to convert your Original Text Strings, format cell as Date:

Book1
	E	F
2	20180809173450Z	8/9/2018
3	201818070121Z	7/18/2018
Sheet178

Cell Formulas
Range	Formula
F2	=(MID(E2,5,2)&"/"&MID(E2,7,2)&"/"&LEFT(E2,4))+0
F3	=(MID(E3,7,2)&"/"&MID(E3,5,2)&"/"&LEFT(E3,4))+0