Wiki Sumber Informasi iSIKHNAS

Proceed as follows:

1. Cut the existing column E, and paste it into column H:
   
2. Select the cells that need to be split (here, they are H3:H10).
3. From the 'Peralatan Data' section of the 'Data' tab of the Ribbon, click on 'Teks ke Kolom'.
4. Check the 'Dibatasi' option on the first step of the wizard, then click 'Berikutnya'.
   
5. We must now tell Excel what character/s should be used to split apart the cell contents.
   • The preview area at the bottom of the dialog box shows the effects of the delimiter/s selected.
   • We see that using a space alone will not work for all rows:
     
   • However, using '(' as well as a space does split the numbers from the remainder of the cell entries:
     
6. Click 'Berikunya' to move to the final step of the wizard.
7. Each column in turn can be processed:
   • The field can be retained, or skipped (not imported)
   • The data category can be assigned.
   • We choose to omit the 'Shed' field:
     
   • Click 'Selesai' to finish.