#Excel #powerquery #texttocolumn #INTfunction #exceltutorial #shorts
To split or separate date and time values in excel can be challenging especially when you are importing data from external sources and you are required to first do data cleaning in excel before you load your date into excel features for data analysis. We have several options of splitting our date and time values including using formulas like INT, MOD and also TEXT to Columns feature.