Help Formatting Numbers in Formulas

As below and attached, I have a cell with file names, which I then strip the date & time from using mid-selection, to give ...


ABC_20230519_230043 20230519 2300



I would ideally like to format the date and time cells, so date column is yyyyy-mm-dd and the time column is hh:mm.


Is there any way of doing this directly, without adding more columns of calculations? formatting as time, date or custom isn't working for me.

Thanks.