Ask Your Question

How to separate date and time from one column to two? [closed]

asked 2013-09-17 18:39:33 +0100

kapcom01 gravatar image

updated 2013-09-17 18:51:01 +0100

I have a column with YY-MM-DD HH:MM and i want to split it into two columns, on for the date and one for the time. How ca I do it?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-08 21:00:03.010383

1 Answer

Sort by » oldest newest most voted

answered 2013-09-17 20:56:15 +0100

m.a.riosv gravatar image

updated 2013-09-17 20:56:59 +0100

Menu/Data/Text to columns

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-17 18:39:33 +0100

Seen: 3,251 times

Last updated: Sep 17 '13