How to extract date in excel spreadsheet using LEFT and RIGHT function?-CodePudding

The date is in following format- " yyyy/mm/dd hr/min/sec " I want to separate date and time in two different columns.

CodePudding user response：

for year: LEFT(A1,4) for mm: MID(A1,6,2) for dd: MID(A1,9,2) for hr: MID(A1,12,2) for mm: MID(A1,15,2) for ss: RIGTH(A1,2)

CodePudding user response：

If It is string, Then look for the space character to take them apart: like this:

Date Part:

=LEFT(A1,FIND(" ",A1))

Time Part:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Then you can format your columns to adapt to your settings: