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