View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Separating Two Data Sets from one Excel Cell into Two Cells

The MID() function would work for you the number of columns is always
the same. Your example shows spaces before and after the yy, which you
could also use to your advantage in a SEARCH() function (as one of the
arguments in a MID function). Can you post a few actual examples?