Copy the data to the second sheet *after* you perform the separation on the
first sheet!
OR
Remove you linking formula on the second sheet and leave the data behind by:
<copy <paste special <values, and *then* do the TTC.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Caleb" wrote in message
...
Thank you Gary's Student! I can get it to work great on the same sheet as
the initial cell. If a cell on sheet two is set to equal the cell with
multiple values on sheet one, it does not work. Thank you for your help
and
I'll keep playing with it.