Text to column

[Raghadhq]

Hi there,

i have problem in splitting the column in the file attached as it won't split the date and time in different column.

Thanks

[TimN]

Hi,

Here is one way.

[rzdodson]

@Raghadhq adding three more potential solutions for you based on scenarios I can think of. Appended below is a screenshot of the third method using Regex_Replace inside of a Multi-Field Formula to clean the time-related fields you are targeting. 

[nagakavyasri]

One way of doing this: