Setup Excel to autosplit one cell into two
 

I get a file with date and time on the following format YYYY-MM-DD HH:MM (24
hour system) and would like to split this information into two new columns
called "date" and "time". Is there a way to set this up so Excel could do
this by itself?

Setup Excel to autosplit one cell into two
 

try the text to column wizard
split on the space.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Zonic wrote :

I get a file with date and time on the following format YYYY-MM-DD
HH:MM (24 hour system) and would like to split this information into
two new columns called "date" and "time". Is there a way to set this
up so Excel could do this by itself?