Formatting a Date from a number

[Nils_Junker]

Hi everybody

i have the following question:

I have a cell with the content: 202305261350. Now this is a date but not formatted properly.
Is it possible that i can extract this cell so that it is splitted in two cells like the following:
Cell1: DD.MM.YYYY (26.05.2023) Cell2: HH:MM (13:50)

I think this should be feasible.

Thanks for helping

 

[FormR]

You can extract and convert the date and time like this:

Book5
	A	B	C
1	202305261350	26/05/2023	13:50:00
Sheet1

Cell Formulas
Range	Formula
B1	B1	=0+TEXT(LEFT(A1,8),"0000-00-00")
C1	C1	=0+TEXT(RIGHT(A1,4),"00\:00")

You can then format them how you please.