Convert/Split Excel into dd-mmm-yyyy hh:ss into 2 variables or fields

Callos_James_AU · March 4, 2020, 2:08am

Hello Everyone

Anyone here tried to convert or split a value like this “180620191412” into dd-mmm-yyyy and hh:mm in excel file? Appreciate your help. Thanks guys

Yoichi · March 4, 2020, 2:33am

Hi,

Hope the following sample helps you.

Regards,

lakshman · March 4, 2020, 2:33am

You need to define column in that format in Excel file and then check it once.

Callos_James_AU · March 4, 2020, 4:24am

Hello @Yoichi! Thanks for always answering my query You’re a star!!!

system · March 7, 2020, 4:24am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.