Hello,
I have a long column of combined date and time. Here is a portion of it:
What I need is two columns, one of the date, and one of the time. I've tried using the Text to Column function (Delimited, space delimiter), and the preview looks just like I would like to see it:
But, when I click on Finish I get this:
The desired result was the date only, yet I still get the trailing 0:00 after the date. Either I am not using the Text to Column function properly or it's the wrong function to use. Any help that someone might give me would be greatly appreciated. Thank you. A
I have a long column of combined date and time. Here is a portion of it:
What I need is two columns, one of the date, and one of the time. I've tried using the Text to Column function (Delimited, space delimiter), and the preview looks just like I would like to see it:
But, when I click on Finish I get this:
The desired result was the date only, yet I still get the trailing 0:00 after the date. Either I am not using the Text to Column function properly or it's the wrong function to use. Any help that someone might give me would be greatly appreciated. Thank you. A