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?
|