Thread: Setup Excel to autosplit one cell into two
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Zonic Zonic is offline
external usenet poster
  
Posts: 1
Default 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?
Reply With QuoteReply With Quote