Q:

Power Query, Split Column Date and Time not Working

Kindly to help me how to split column date and time, in the original file sources dd-mmm-yyyy (double space) hh:mm:ss

The problem is all the column extracted date only (I need the time also), please see the picture

And here are the code 
let
    Source = Excel.Workbook(File.Contents("D:\IP_Enquiry_Result_20181015_082020.xls"), null, true),
    #"Enquiry Result1" = Source{[Name="Enquiry Result"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(#"Enquiry Result1",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}, {"Column14", type text}, {"Column15", type text}, {"Column16", type text}, {"Column17", type text}, {"Column18", type text}, {"Column19", type text}, {"Column20", type text}, {"Column21", type text}, {"Column22", type text}, {"Column23", type text}, {"Column24", type text}, {"Column25", type text}, {"Column26", type text}, {"Column27", type text}, {"Column28", type text}, {"Column29", type text}, {"Column30", type text}, {"Column31", type text}, {"Column32", type text}, {"Column33", type text}, {"Column34", type text}, {"Column35", type text}, {"Column36", type text}, {"Column37", type text}, {"Column38", type text}, {"Column39", type text}, {"Column40", type text}, {"Column41", type text}, {"Column42", type text}, {"Column43", type text}, {"Column44", type text}, {"Column45", type text}, {"Column46", type text}, {"Column47", type text}, {"Column48", type text}, {"Column49", type text}, {"Column50", type text}, {"Column51", type text}, {"Column52", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Column47] <> null)),
    #"Promoted Headers" = Table.PromoteHeaders(#"Filtered Rows", [PromoteAllScalars=true])
in
    #"Promoted Headers"

A:

I found the way to make it appear, it used microsoft query and everthing was fine.
I tried to use 'MS OLE DB Provider for ODBC driver' but the excel sources cannot be replaced.
Thank you everyone for your help, have nice day :)

