Wiki Sumber Informasi iSIKHNAS

We will use the 'Teks ke Kolom' wizard to split apart the data. The outputs will be placed in the cells on top of, and (if more than one) to right of the selected ones. In our case, we will have two pieces of output data. As we do not want the existing data in columns F and G to be overwritten, we must either INSERT enough columns to capture the split-out data, or move the data to the far right of the data region, so that nothing will be overwritten. We will demonstrate this second option.