Date and time in the same Excel cell

could you help me to solve how I can have the date and time that is in the same box of the excel take me to take them in two different boxes on the page



First read the data from each cell and split it based on space as delimiter.

Eg. inputStr = “28/01/2020 19:37”
dateStr = inputStr.Split(" “c)(0)
timeStr = inputStr.Split(” "c)(1)