Nils_Junker
Board Regular
- Joined
- Jun 2, 2023
- Messages
- 80
- Office Version
- 365
- Platform
- Windows
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
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